VB.NET--Stored Procedures?

There are 2 tables in “GoodCompany” database “Customers” and “Sales”. You have a valid connection string called “MyConnection” with default database set to “GoodCompany”.








“Customers” has “CustID” as primary key/identity and “FullName” field.








“Sales” has “ProdID” as primary key/identity, “ProductName”, and “CustID” that is foreign key to the “Customers” table.





SELECT CustID, FullName, ProdID, ProductName


FROM Customers c, Sales s


WHERE c.CustID = s.CustID





Please do the following using ADO.NET:





Create a Stored Procedure that takes CustID as a parameter and returns all Sales for that customer along with Customer’s name.





Explain how to populate a GridView with this data.VB.NET--Stored Procedures?
And the compensation for completing this is???


You will do better to at least try, post what code you've got, THEN ask for help. As the old saying goes :





';The Coding Gods help those who help themselves';

web hosting talk

loan