Question

asp.net怎么用代码显示GridView

不用数据源绑定数据的方式，直接用代码把数据库里面的数据显示到GridView中。
我是新手，希望能有详细的代码和操作！！

Answer 1

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

Answer 2

现写的一段代码.力求做到最简单了.呵呵.贴进去就可以用
SqlConnection conn = new SqlConnection("Server=.;uid=sa;pwd=sa;database=Northwind");
conn.Open();
SqlCommand cmd = new SqlCommand("select * from employees", conn);
SqlDataReader dr= cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
GridView1.DataSource = dt;
GridView1.DataBind();
conn.Close();

Answer 3

Rows.Add(object[] params)