求.net连接access(C#)如何连接? 求.net连接access(C#)如何连接?哪个提供个例子看看啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\yourdb.mdb"); conn.Open(); web.config 里面 <add name="ptsgeDBconnstr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ptsge\DB\ptsgeDB.mdb;User Id=admin;Password=;" providerName="System.Data.OleDb"/>string myallconn = (System.Configuration.ConfigurationManager.ConnectionStrings["ptsgeDBconnstr"]).ToString();//取得字符串之后就做你应该做的啦 web.config 里面 : <connectionStrings> <add name="myConn" connectionString="~/Data/DB.mdb"/> </connectionStrings> public static OleDbConnection GetConn() { OleDbConnection Conn; string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString); string ConnString = myConnectionString; Conn = new OleDbConnection(ConnString); return Conn; } 首先,使用命名空间:using System.Data.Odbc;其次,添加代码:OdbcConnection thisConnection = new OdbcConnection(@"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:\db1.mdb;");thisConnection.Open();连接其他数据库也是类似。下面是我学习的时候,用来连接公司Firebird数据库的一段代码,是在控制台环境下运行的,呵呵,你可以模仿一下OdbcConnection thisConnection = new OdbcConnection(@"DRIVER=Firebird/InterBase(r) driver;UID=sysdba; PWD=MASTERKEY;CLIENT=d:\soft\\Firebird\bin\fbclient.dll;DBNAME=d:\ssDB.FDB;"); thisConnection.Open(); OdbcCommand thisCommand = thisConnection.CreateCommand(); thisCommand.CommandText="SELECT * FROM \"chChild\""; OdbcDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read()) { Console.WriteLine("\t{0}\t{1}", thisReader["FChildNo"],thisReader["FBirthDay"]); } thisReader.Close(); thisConnection.Close(); Console.Write("============end=========="); Console.ReadLine(); //String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source="; //connectionString += @"d:\jinXiaoCun.mdb"; //OleDbConnection myConnection = new OleDbConnection(connectionString); //myConnection.Open(); //打开数据库链接 //OleDbDataAdapter objAdap = new OleDbDataAdapter("SELECT * FROM f_jinhuodan", myConnection); //DataSet objDSet = new DataSet(); //objAdap.Fill(objDSet, "f_jinhuodan"); //dataGridView1.DataSource = objDSet.Tables[0].DefaultView; 查询 OleDbConnection类就用这个类就行另外还要用到datareader或者OleDbDataAdapter找本c#的书来看,基础一点的基本上所有的书都会涉及到跟数据库的连接 string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sPath + ";Extended Properties='Excel 12.0 Xml;HDR=NO;IMEX=1'"; 求大神指点!! 获取IE标题高度---winform的---- DataGridView 合并列出现的问题 vista下没有写文件的权限 c#关于c/s结构 计算上机时间的问题 小弟不才,问题见图! 有没有开发类似Workflow Designer的图形技术或框架 DataGridView内嵌按钮列标题不能显示,怎么解决? DotNetBar 树形操作 求各位大神帮帮忙 为什吗 页面不显示了。。。。 string赋值--新手问题
conn.Open();
<add name="ptsgeDBconnstr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ptsge\DB\ptsgeDB.mdb;User Id=admin;Password=;" providerName="System.Data.OleDb"/>string myallconn = (System.Configuration.ConfigurationManager.ConnectionStrings["ptsgeDBconnstr"]).ToString();//取得字符串
之后就做你应该做的啦
<connectionStrings>
<add name="myConn" connectionString="~/Data/DB.mdb"/>
</connectionStrings>
public static OleDbConnection GetConn()
{
OleDbConnection Conn;
string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
string ConnString = myConnectionString;
Conn = new OleDbConnection(ConnString);
return Conn;
}
其次,添加代码:
OdbcConnection thisConnection = new OdbcConnection(@"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:\db1.mdb;");
thisConnection.Open();连接其他数据库也是类似。
下面是我学习的时候,用来连接公司Firebird数据库的一段代码,是在控制台环境下运行的,呵呵,你可以模仿一下
OdbcConnection thisConnection = new OdbcConnection(@"DRIVER=Firebird/InterBase(r) driver;UID=sysdba; PWD=MASTERKEY;CLIENT=d:\soft\\Firebird\bin\fbclient.dll;DBNAME=d:\ssDB.FDB;");
thisConnection.Open();
OdbcCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText="SELECT * FROM \"chChild\"";
OdbcDataReader thisReader = thisCommand.ExecuteReader();
while (thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",
thisReader["FChildNo"],thisReader["FBirthDay"]);
}
thisReader.Close();
thisConnection.Close();
Console.Write("============end==========");
Console.ReadLine();
//connectionString += @"d:\jinXiaoCun.mdb";
//OleDbConnection myConnection = new OleDbConnection(connectionString); //myConnection.Open(); //打开数据库链接
//OleDbDataAdapter objAdap = new OleDbDataAdapter("SELECT * FROM f_jinhuodan", myConnection); //DataSet objDSet = new DataSet();
//objAdap.Fill(objDSet, "f_jinhuodan");
//dataGridView1.DataSource = objDSet.Tables[0].DefaultView;
就用这个类就行
另外还要用到datareader或者OleDbDataAdapter
找本c#的书来看,基础一点的
基本上所有的书都会涉及到跟数据库的连接