SqlDataAdapter Not working with parameters from C#

Question

Hi I build a SqlDataAdaptor in VS2003 and I am trying to get a set of records from a table using a stored procedure. I have tested the stored procedure and it generates the correct data. I have also tested the dataadaptor and it seems to work just fine. However when I work it from C# I get an empty dataset. (Also the dataset was built using VS as well). Here is the code. Can any one tell me what is wrong here? this.sqlDataAdapter3.SelectCommand.Parameters[@NameID].Value = 1; this.sqlDataAdapter3.Fill(dsDNames); foreach(DataRow row in dsDNames.TraningDates.Rows) { Console.WriteLine(row[1]); }

mjsnow · Answer

The problem with the code was naming the table in the fill method of the adaptor. I built the dataset using Visual Studio and thought that it would name the table after the table in the dataset but it didn’t work that way. When I referenced the table name I thought was in the dataset it wasn’t there just a table named table. To correct the code I added the table name to the fill operation: This.sqlDataAdapter3.Fill(dsDNames tblPetNames). It seems to work ok.

jesuprakash · Answer

May be you have not declared the select command as a stored procedure... Please try: this.sqlDataAdapter3.SelectCommand.CommandType = CommandType.StoredProcedure;