private void Form1_Load(object sender, System.EventArgs e)
{
OleDbConnection lianjie =new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\新建 Microsoft Office Access 应用程序.mdb");
lianjie.Open();
OleDbDataAdapter chaxun =new OleDbDataAdapter("select * from biao where Q='1'",lianjie);
chaxun.Fill(tcc,"biao");
lianjie.Close();
this.dataGrid1.DataSource=tcc;
//如果是WebForm
加上 this.dataGrid1.DataBind(); }
{
OleDbConnection lianjie =new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\新建 Microsoft Office Access 应用程序.mdb");
lianjie.Open();
OleDbDataAdapter chaxun =new OleDbDataAdapter("select * from biao where Q='1'",lianjie);
chaxun.Fill(tcc,"biao");
lianjie.Close();
this.dataGrid1.DataSource=tcc;
//如果是WebForm
加上 this.dataGrid1.DataBind(); }
是DataSet tcc
using System.Data;
using System.Data.OleDb; private void button9_Click(object sender, System.EventArgs e)
{
string source=@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:\North.mdb";
string strsql="select * from supply"; OleDbDataAdapter da=new OleDbDataAdapter(strsql,source);
DataSet ds=new DataSet();
da.Fill(ds,"tab");
dataGrid1.SetDataBinding(ds,"tab");
}
using System.Data;
using System.Data.OleDb; private void button9_Click(object sender, System.EventArgs e)
{
string source=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\新建 Microsoft Office Access 应用程序.mdb";
string strsql="select * from biao where Q='1'"; OleDbDataAdapter da=new OleDbDataAdapter(strsql,source);
DataSet ds=new DataSet();
da.Fill(ds,"tab");
dataGrid1.SetDataBinding(ds,"tab");}你自己上機調試看看﹗不行的再說﹗
chaxun.Fill(tcc,"biao");
this.dataGrid1.DataSource=tcc.Tables[0];