.net 如何连接access数据库？

[wolfqixianfeng]

.net 如何连接access数据库？并对其操作如何？

[TheAres]

private System.Data.OleDb.OleDbConnection Conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=c:\db.mdb");

[jinus]

嗯，还可以加上密码，或者访问系统数据库。
import System.Data;
import System.Data.OleDb;
...

string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\...\MySecure.MDB;
Jet OLEDB:System database=C:\...\MySystem.MDW;
User ID=MyUserName;Password=MyPassword;"
OleDbConnection Conn = new OleDbConnection(connStr);

[码视野]

呵呵，都说完了！！

[SimonSnow]

OleDbDataAdapter da=new OleDbDataAdapter("SELECT * FROM table1",conn);
DataSet ds=new DataSet;
da.Fill(ds);

[duying]

我在补充一点，建议你搜索csdn，你定会有搜获 ：）

[3no]

http://www.csdn.net/Develop/read_article.asp?id=16437
.NET中各种数据库连接大全

[mmvr]

gz

[wxjUN]

我来补上操作的

string ConnStr="Provider=Microsoft.Jet.OLEDB.4.0;password=;user id=Admin;Data Source=qymlk.mdb";
OleDbConnection Cmd;
Cmd=new OleDbConnection(ConnStr);
Cmd.Open();
OleDbCommand Cmd1;
//删除
Cmd1=new OleDbCommand("delete from tjb2 ",Cmd);
Cmd1.ExecuteNonQuery();
//插入
Cmd1=new OleDbCommand("insert into tjb2(gs1,cz) select count(*),sum(zcz) from mlkb1 where xz='镇集体'",Cmd);
Cmd1.ExecuteNonQuery();
//更改
Cmd1=new OleDbCommand("update tjb1 set gs1="+yy0+" where xh1='02' ",Cmd);
Cmd1.ExecuteNonQuery();

[zhehui]

搞定了，这样写就行
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;User ID=Admin;Password=;Jet OLEDB:Database Password=pass";

[glen]

using System.Data;
using System.Data.OleDb;
---------------------------
OleDbConnection thisConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\D\DevCs\Works2\Person.mdb;");
thisConnection.Open();
OleDbCommand thisCommand=thisConnection.CreateCommand(); //
thisCommand.CommandText="SELECT * FROM Intro";
OleDbDataReader thisReader=thisCommand.ExecuteReader();
while(thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",thisReader["ID"],thisReader["TheName"]);
}
thisReader.Close();
thisConnection.Close();

[vikey]

Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password='***'; Password='***';User ID=Admin;Data Source=" + Application.StartupPath + "\\*.mdb
//Jet OLEDB:Database Password :数据库密码

[码视野]

string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\...\MySecure.MDB;
Jet OLEDB:System database=C:\...\MySystem.MDW;
User ID=MyUserName;Password=MyPassword;"
OleDbConnection Conn = new OleDbConnection(connStr);

怎么还不揭帖？

[zhehui]

搞定了，这样写就行，这是一个加密码的数据库访问
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;User ID=Admin;Password=;Jet OLEDB:Database Password=pass";