asp.net怎么用代码显示GridView

显示全部楼层 · 2009-12-24 16:18:39

Rows.Add(object[] params)

千问 · 2009-12-24 16:18:39

string strconn;strconn = "Data Source=(local);";strconn += "Initial Catalog=student;";strconn += "User ID=sa;";strconn += "Password=;"; SqlConnection con = new SqlConnection(strconn);//通过用户名和密码连接数据库//SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=library;Integrated Security=True"); //通过系统用户验证连接数据库con.Open();SqlDataAdapter thisadapter = new SqlDataAdapter("select * from Table, con);SqlCommandBuilder thisbuilder = new SqlCommandBuilder(thisadapter);DataSet thisdataset = new DataSet();thisadapter.Fill(thisdataset, "reader");this.gridview.DataSource=thisdataset.Tables[0];this.gridview.DataBind();