简单的用法:SqlConnection conn = new SqlConnection("Server=(local);DataBase=test;User=sa;Pwd=sa"); SqlDataAdapter da = new SqlDataAdapter("select * from test", conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0];
少了绑定 bindingsource1.DataBind();
SqlConnection conn = new SqlConnection("server=.;database=数据库名;uid=sa;pwd=sa"); SqlDataAdapter da = new SqlDataAdapter("select * from test", conn); DataSet ds = new DataSet(); da.Fill(ds); bindingsource1.datasource=dataset1; dataGridView1.DataSource = bindingsource1;
你的数据时自己绑定的还是自己写的。如果是自己写的就要在模板列绑定数据“Eval("要绑定的内容")
using(SqlConnection connectionString =new SqlConnection("")) { SqlDataAdapter customersTableAdapter = new SqlDataAdapter("Select * from Tb", connectionString); DataTable dt= new DataTable(); customersTableAdapter.Fill(dt); BindingSource1.DataSource = dt; dataGridView1.DataSource = BindingSource1; }
SqlDataAdapter da = new SqlDataAdapter("select * from test", conn);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
bindingsource1.DataBind();
SqlDataAdapter da = new SqlDataAdapter("select * from test", conn);
DataSet ds = new DataSet();
da.Fill(ds);
bindingsource1.datasource=dataset1;
dataGridView1.DataSource = bindingsource1;
{
SqlDataAdapter customersTableAdapter =
new SqlDataAdapter("Select * from Tb", connectionString);
DataTable dt= new DataTable();
customersTableAdapter.Fill(dt);
BindingSource1.DataSource = dt;
dataGridView1.DataSource = BindingSource1;
}