Question

为什么用datagirdview显示不了。

private void FrmBookRevise_Load(object sender, EventArgs e)
{
DataTable mydt = new DataTable();
SqlConnection conn = Sqlclient.Client();
conn.Open();
string cmd = "select bId as 图书编号,bName as 图书名称,bNumber as 数量,bSore as 类别 from Bmanage";
SqlDataAdapter adpter = new SqlDataAdapter(cmd, conn);
DataSet myds = new DataSet();
adpter.Fill(myds);
mydt = myds.Tables[0];
BindingSource bds = new BindingSource();
dataGridView1.DataSource = bds;
bds.DataSource = mydt;
}

Answer 1

1. SqlConnection conn = Sqlclient.Client(); 这句Client是你的自定义函数？

2. adpter.Fill(myds)后面直接dataGridView1.DataSource = myds.Tables[0];其他都删除试试
   
   

Answer 2

SqlDataReader sdr = cmd.ExecuteReader();
dataGridView1.DataSource = sdr;
这里改成下面的试试
sqldataadapter da=new sqldataadapter(sql,Dac.conn);
datatable dt=new datatable();
da.fill(dt);
dataGridView1.DataSource =dt;