如何使用ASP.net C#将SQL选择存储到gridview? [英] How to store SQL select to gridview using ASP.net C#?

问题描述

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

这是我的选择声明.我想将结果放入数据gridview.如何在asp.net C#中使用数据集存储在gridview中?

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#?

推荐答案

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

这篇关于如何使用ASP.net C#将SQL选择存储到gridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！