Question

VS2008中控件gridview的问题

如何用SQL语句从数据库中某个表格里拿出数据放进DATATABLE中 然后在赋值给gridview

Answer 1

string sqlstr = ConfigurationManager.ConnectionStrings["XCEConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(sqlstr);
conn.Open();

string sqlcmd = "select * from Book";
SqlDataAdapter sda = new SqlDataAdapter(sqlcmd, conn);
DataTable myTable = new DataTable();
sda.Fill(myTable);
GridView1.DataSource = myTable;
GridView1.DataBind();
conn.Close();

Answer 2

你怎么邦定droplist，gridview一样邦定啊！上楼错出来了！