string databasestr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb";
string databasesql="select * from t1";
OleDbConnection databaseconn=new OleDbConnection();
databaseconn.ConnectionString=databasestr;
OleDbDataAdapter da=new OleDbDataAdapter(databasesql,databaseconn);
DataSet ds=new DataSet();
da.Fill(ds,"t1");
dataGrid1.SetDataBinding(ds,"t1");
string databasesql="select * from t1";
OleDbConnection databaseconn=new OleDbConnection();
databaseconn.ConnectionString=databasestr;
OleDbDataAdapter da=new OleDbDataAdapter(databasesql,databaseconn);
DataSet ds=new DataSet();
da.Fill(ds,"t1");
dataGrid1.SetDataBinding(ds,"t1");
解决方案 »
- C#调用Java的有安全认证的CXF,C#端如何写?
- 关于Xenocode Postbuild 打包,求教
- 求助,窗口最大化,上边空一块!
- c#数据转换,感觉有点难度
- 是MS超大bug?!每次在VS2005里调试WinForm时,按F10继续都没反应
- 关于DataGrid的翻页删除问题!
- WebBrowser.Navigate加载pdf文件后,程序退出报内存错误
- 急,虚拟表配制,绑定问题,50分
- C# winform dataGridView 中如何设置滚动条的宽度 帮帮忙谢谢大家
- 我想调用api编辑(*.res)文件,但是搞了半天也没成,大家帮个忙?
- 如何让程序随机产生20个不同的颜色?烦请给出代码!
- 自定义用户控件无法应用,急,大家帮帮忙
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""
OLEDB, OleDbConnection (.NET)
Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=asdasd;"
Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""
With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""
呵呵
using system.data.sqlclient
string strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=yourAccessFilepath.mdb";
SqlConneciotn myconn = new Sqlconnection(strConn);
myconn.open;
string sql="select * from customer";
OleDbConnection con=new OleDbConnection(str);
OleDbDataAdapter da=new OleDbDataAdapter(sql,con);
DataSet ds=new DataSet();
da.Fill(ds,"customer");
using System.Data;
using System.Data.OleDb;
2.
声明变量:
private OleDbConnection mConn;
3.
在需要用到的地方调用下面的方法:
private void InitConn()
{
string strSource;
strSource="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=DataBaseName.mdb";
mConn=new OledDbConnection(strSource);
}
4.剩下的就是取出数据的问题了:
private void InitData()
{
string sql="select * from myTableName";
OleDbDataAdapter da=new OleDbDataAdapter(sql,mConn);
//读取数据形式可用多种方式,用OleDbDataAdapter或OleDbCommand均可
DataSet ds=new DataSet();
mConn.Open();
da.Fill(ds);//可指定表名,也可不指定
//这样就将数据读取到你的ds数据集当中了。
mConn.Close();
}