I'm trying to fill a Dataset. It worked when I did it by direct query but have moved to a stored procedure. The stored procedure does work and returns the rows desired with the desired userID/Password.
var connectionString = ConfigurationManager.ConnectionStrings["InformConnectionString"].ConnectionString;
var MyConnection = new SqlConnection(connectionString);
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.Connection = MyConnection;
cmd.CommandText = "sp_genDSPdata";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@startdate", SqlDbType.DateTime).Value = Convert.ToDateTime(startString);
cmd.Parameters.Add("@enddate", SqlDbType.DateTime).Value = Convert.ToDateTime(endString);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
adap.Fill(ds);
return ds;
ds has a count of 0. When I execute the sp, it returns about 2500 rows. I have tried many things and this is my latest attempt. Does anyone see anything obviously wrong? No errors. Just empty ds. I had an error in the fill when I tried to pass strings because it was an incorrect sqldatatype. This tells me that it tried to execute the sp. So, I converted the strings to datetime and it went to the next line but the ds is empty. Hope this is enough info.
Well, for those of you that might seem interested, I was not naming my table. This prevented my program from reading the information from the correct place. Consequently, null was all I ever got. I knew it had to be something basic. Thank you for your interest.