asp.net中如何连接access数据库
求连接access数据库的代码。 --------------------编程问答--------------------using System.Data.OleDb;--------------------编程问答-------------------- ado.net 数据库操作 dbhelper
using System.Data;
//连接指定的Access数据库
String ConnString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyMDB.mdb";
//SQL语句
String SQLString ="select * from TestDB";
//创建一个OleDbConnection对象
System.Data.OleDb.OleDbConnection OleDBConn1 = new System.Data.OleDb.OleDbConnection(ConnString);
//创建一个DataSet对象
DataSet DataSet1 = new DataSet();
//创建一个OleDbDataAdapter对象
System.Data.OleDb.OleDbDataAdapter OleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(SQLString,OleDBConn1);
//打开连接
OleDBConn1.Open();
//通过OleDbDataAdapter对象填充数据集
OleDbDataAdapter1。Fill(DataSet1,"TT");
连接字符串成
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>
public static OleDbDataReader ExecuteReader(string strSQL)
{
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(strSQL, connection);
try
{
connection.Open();
OleDbDataReader myReader = cmd.ExecuteReader();
return myReader;
}
catch (System.Data.OleDb.OleDbException e)
{
throw new Exception(e.Message);
}
}
--------------------编程问答--------------------
--------------------编程问答--------------------
System.Data.OleDb.OleDbConnection OleDBConn1 = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=你的数据库名称.mdb");
--------------------编程问答--------------------
.......省略,定义变量
{
string srtCon = @"provider=Microsoft.jet.OLEDB.4.0;Data source=db.mdb";//数据库地址
OleDbConnection con = new OleDbConnection(srtCon);
OleDbCommand com = new OleDbCommand(srtCon);
con.Open();
com.CommandText = "Select qj,xf,kg_5,kg_50,kg_100 from data where dq like '"+mdd+"'";//数据库条件查询语句
com.CommandType = CommandType.Text;
com.Connection = con;
OleDbDataReader reader = com.ExecuteReader();
reader.Read();
//分别获取数据库并赋值
qj = reader.GetInt32(0);
xf = reader.GetInt32(1);
kg_5 = reader.GetInt32(2);
kg_50 = reader.GetInt32(3);
kg_100 = reader.GetInt32(4);
con.Close();
}
注意:需要先在头部添加引用:using System.Data.OleDb; 命名空间。
连接,查询,获取值都有了。直接拿去用就ok
+1 --------------------编程问答-------------------- <add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>
喜欢这句~ --------------------编程问答-------------------- 最简单就是托个控件。 --------------------编程问答-------------------- 在web config中 作如下配置:
<connectionStrings>
<add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
OleDbConnection Con = new OleDbConnection(System.Configuration .ConfigurationManager.ConnectionStrings ["ydycon"].ToString() );
//OleDbConnection Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ydy.mdb"));
// SqlConnection Con = new SqlConnection(ConStr);
Con.Open();
补充:.NET技术 , ASP.NET