SqlDataAdapter Not working with parameters from C#

mjsnow

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]); }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

mjsnow21y ago
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.
jesuprakash21y ago
May be you have not declared the select command as a stored procedure... Please try: this.sqlDataAdapter3.SelectCommand.CommandType = CommandType.StoredProcedure;