c#-datagridview动态绑定问题
来源:百度知道 编辑:UC知道 时间:2024/05/20 00:40:49
SqlConnection conn = new SqlConnection("Data Source=.;User ID=sa;Password=sa;Initial Catalog=Test;");
DataSet ds = new DataSet();
string sql = "secect * from Table1";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
1,select写错
2,如果是winform程序不用dataGridView1.DataBind();
如果是webform则:dataGridView1.DataBind();
string sql = "secect * from Table1";
迷糊,sql语句写错了应该是select
DataSet = new DataSet();
DataTable DataTable = new DataTable();
DataTable.TableName = "Table1";
DataSet.Tables.Add(DataTable);
...
DataGridView.DataSource = DataSet;
DataGridView.DataMember = DataSet.Tables[0].TableName;
这就绑定好了
sql写的有问题啊
SqlConnection conn = new SqlConnection("Data Source=.;User ID=sa;Password=sa;Initial Catalog=Test;");
DataSet ds = new DataSet();
string sql = "secect * from Table1";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
conn.Open();
da.Fill(ds);
conn.Close();
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.DataBind();
这样就可以咯!
dataGridView1.DataSource = ds.Tables[0];要改为
ds.T