title: How to store SQL select to gridview using ASP.net C#?
body: <pre><code> SqlCommand cmd = new SqlCommand("SELECT * FROM [order] WHERE date&gt;=@begin AND date&lt;=@end", con);
   cmd.Parameters.AddWithValue("@begin",dt1);
   cmd.Parameters.AddWithValue("@end", dt2);
  </code></pre>
  
  <p>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#?</p>