有一个GridView1
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
用DataReader读数据库信息
SqlConnection sqlCon = new SqlConnection();sqlCon.ConnectionString = "Data Source=.;DataBase=Bu;UID=sa;PWD=密码;"; //连接字符串SqlCommand cmd = new SqlCommand("select * from tableA",sqlCon); //sql语句或存储过程sqlCon.Open();SqlDataReader dr = cmd.ExecuteReader();
将内存中的数据流作为数据源绑定给GridView
GridView1.DataSource = dr;GridView1.DataBind();
炒鸡简单吧，额呵呵~
同理，绑定DataSet和DataTable也是一样的。将DataSet填充数据集（一个DataSet可有多个DataTable）
SqlConnection sqlCon = new SqlConnection();sqlCon.ConnectionString = "Data Source=.;DataBase=Bu;UID=sa;PWD=密码;"; //连接字符串SqlCommand cmd = new SqlCommand("select * from tableA",sqlCon); //sql语句或存储过程 sqlCon.Open();SqlDataAdapter da = new SqlDataAdapter("select top 3 * from menber", sqlCon);DataSet ds = new DataSet();da.Fill(ds, "menber");
DataTable dt = ds.Tables[0]; //DataSet里第一张表赋给DataTable
将ds或者dt绑定给GridView
GridView1.DataSource = ds;//也可以是dtGridView1.DataBind();
炒鸡简单吧，额呵呵~
