dataGridView winform 数据怎样绑定?
OleDbConnection mc = Form1.Connectdata();
string strSql = "SELECT * FROM [tablename]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "tablename");
// ??
// ? ?
OleDbConnection mc = Form1.Connectdata();
string strSql = "SELECT * FROM [tablename]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "tablename");
// ??
// ? ?
dataGridView.DataSource = ds;
dg.DataMember = ds.Tables["tablename"];
dataGridView.DataSource = ds;
dataGridView.DataMember = "tablename";
或直接
dataGridView.DataSource = ds.Tables[0];
或
dataGridView.DataSource = ds.Tables["tablename"];
OleDbConnection mc = Form1.Connectdata();
string strSql = "SELECT * FROM [tablename]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
DataSet ds = new DataSet( );
//??
//??
//dg.DataMember = ds.Tables["tablename"];//这句报错...
ds.Tables["tablename"];这句返回一个表对象
而dg.DataMember接受的是字符串.主要用于设置相应的表名
如果你知道tablename就直接用dg.DataMember ="tablename"
不过你之前必须加句dg.DataSource = ds;
以下三种使用
dg.DataSource = ds;
dg.DataMember = "tablename";
或直接
dg.DataSource = ds.Tables[0];
或
dg.DataSource = ds.Tables["tablename"];
NO.1
OleDbConnection mc = Form1.Connectdata();
string strSql = "SELECT * FROM [tablename]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, mc );
DataSet ds = new DataSet( );
dg.DataSource = ds;
dg.DataMember = "tablename";
NO.2
OleDbConnection mc = Form1.Connectdata();
string strSql = "SELECT * FROM [tablename]";
OleDbDataAdapter da = new OleDbDataAdapter(strSql, mc );
DataSet ds = new DataSet( );
dg.DataSource = ds.Tables["tablename"];
如果有问题提示什么错误??
第一个提示"无法创建字段 tablename 列名"
或时按默认设置自动创建列..
你查询出来的表是否有数据??
因我正在用这个控件.,.,
我这里可以正常使用,..,.,
直接用dg.DataSource = ds.Tables[0];不行么????