C#.net 连接 access 代码怎么写

来源：百度知道 编辑：UC知道 时间：2024/05/24 19:54:28
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\\db.aspx
这样连接对吗
请教各位高手

1.提取单条记录
//using System.Data;
//using System.Data.OleDbClient;
using (OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\\db.aspx"))
//Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
{
OleDbCommand cmd = new OleDbCommand("Select Count(*) From jobs",cn);
cn.Open();
%%2=cmd.ExecuteScalar(); //Message.InnerHtml
}

2.单值比较
//using System.Data;
//using System.Data.OleDbClient;
using (OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\\db.aspx"))
//Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
{
OleDbCommand cmd = new OleDbCommand("Select Count(*) From jobs",cn);
cn.Open();
%%2=cmd.ExecuteScalar(); //Message.Inne