由网友(打乱节奏)分享简介：SqlCommand cmd = new SqlCommand("SELECT * FROM [order] WHERE date>=@begin AND date<=@end", con);cmd.Parameters.AddWithValue("@begin",dt1);cmd.Parameters.AddWit...

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

这是我的select语句我想把结果数据的GridView如何使用数据集的GridView存放在asp.net C＃帮助尽快

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# help ASAP

推荐答案

使用的 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();