Dear All,
below code i am using to bind grid ,i am usig stored procedure "usp_PBOM_DBOM_ISS_REV01",the procedure excuted with in 15 seconds in sql server but when i was fill the data from adpater to Dataset it will take more then two mintues, i dont know what is the exact problem...
how reduce dataset data fill timing from SqlDataAdapter in c# asp.net
can you provide your solution
SqlCommand cmd = new SqlCommand("usp_PBOM_DBOM_ISS_REV02", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 90000;
cmd.Parameters.Add("@cono", "DNB045000");
cmd.Parameters.Add("@cprj", "DNB045001");
cmd.Parameters.Add("@flag", "G");
cmd.Parameters.Add("@mode", "S");
cmd.Parameters.Add("@catg", "0");
cmd.Parameters.Add("@rpt", "DSG");
// Set chart data source
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
adapter.Fill(dt);
adapter.Dispose();
cmd.Dispose();