How to store SQL select to gridview using ASP.net C#?

Question

 SqlCommand cmd = new SqlCommand("SELECT * FROM [order] WHERE date>=@begin AND date<=@end", con);
 cmd.Parameters.AddWithValue("@begin",dt1);
 cmd.Parameters.AddWithValue("@end", dt2);

This is my select statement. I want to put the result to data gridview. How to use dataset to store in gridview in asp.net C#?

Answer 1

Use a SqlDataAdapter.

SqlCommand cmd = new SqlCommand("SELECT * FROM [order] WHERE date>=@begin AND date<=@end", con);
cmd.Parameters.AddWithValue("@begin",dt1);
cmd.Parameters.AddWithValue("@end", dt2);
SqlDataAdapter sda = new SqlDataAdapater(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
yourGridView.DataSource = dt;
yourGridView.DataBind();

Answer 2

You need a SqlDataReader object to execute your command and a DataTable to load the results into the GridView:

   SqlDataReader dr = cmd.ExecuteReader();
   DataTable dt = new DataTable();
   dt.Load(dr);

   gv.DataSource = dt;
   gv.DataBind();