怎样和access数据库连接? 他自己有oledbconnection呀。按照说明配置一下就可以了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 private string ACCESS_CONNECTION_STRING = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\Northwind.mdb";OleDbConnection ocnnNorthwind= New OleDbConnection(ACCESS_CONNECTION_STRING);ocnnNorthwind.Open(); 同意JacksonH(傲清风) 。另string strConnect = "";OleDbConnection objConn = null; strConnect = @"provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB\db_x.mdb;";//建立数据库连接 objConn = new OleDbConnection();objConn.ConnectionString = strConnect;objConn.Open(); 一个完整的例子代码。OleDbConnection myconn = new OleDbConnection();myconn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\path\\zcdb.mdb";OleDbCommand myselect = new OleDbCommand();myselect.Connection=myconn;string strid;myselect.CommandText="select rcontent from reply where qid='"+strid+"'";try{myconn.Open();myselect.ExecuteNonQuery();OleDbDataAdapter myda = new OleDbDataAdapter();myda.SelectCommand=myselect;DataSet myds = new DataSet("replylist");myda.Fill(myds,"reply");for (int i=0;i<myds.Tables["reply"].Rows.Count;i++){rcontent=myds.Tables["reply"].Rows[i][3].ToString();}}catch(Exception ex){ MessageBox.Show(ex.Message);}myconn.Close(); 搞定了,这样写就行,这是一个加密码的数据库访问"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;User ID=Admin;Password=;Jet OLEDB:Database Password=pass"; C#ping怎么返回多个值 ado 没有这样的功能吗?? OpenOBEX for win32 pakage 请问谁用过?? 如何同时获取不同网站的网页变量,按照时间顺序放在自己的控件里? 如何在字符串下面画一条线 菜鸟的问题:windows窗体应用程序中怎样创建、修改、删除文件?? 请教一个通用性设计的问题(也可能和语法有关) FolderBrowserDialog怎么用Ctrl键多选文件夹啊? 多级目录转换为json数据 这个有什么问题,在类型转换的时候。 一个关于access数据库的写入错误~~~急死我了!请大家帮帮我!救命 谢谢~~~(在线守侯) 访问ACCESS数据库出错,谢谢
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\Northwind.mdb";OleDbConnection ocnnNorthwind= New OleDbConnection(ACCESS_CONNECTION_STRING);ocnnNorthwind.Open();
OleDbConnection objConn = null;
strConnect = @"provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB\db_x.mdb;";//建立数据库连接
objConn = new OleDbConnection();
objConn.ConnectionString = strConnect;
objConn.Open();
OleDbConnection myconn = new OleDbConnection();
myconn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\path\\zcdb.mdb";
OleDbCommand myselect = new OleDbCommand();
myselect.Connection=myconn;
string strid;
myselect.CommandText="select rcontent from reply where qid='"+strid+"'";
try
{
myconn.Open();
myselect.ExecuteNonQuery();
OleDbDataAdapter myda = new OleDbDataAdapter();
myda.SelectCommand=myselect;
DataSet myds = new DataSet("replylist");
myda.Fill(myds,"reply");
for (int i=0;i<myds.Tables["reply"].Rows.Count;i++)
{
rcontent=myds.Tables["reply"].Rows[i][3].ToString();
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
myconn.Close();
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;User ID=Admin;Password=;Jet OLEDB:Database Password=pass";