asp.net怎么连access数据库啊

[cherishahu]

asp.net怎么连access数据库啊
我的书上的例子用的是SQL SERVER ,我的机器装不了,
例子是
using System.data.sqlClient;
SqlConnection con=new SqlConnection("server=.;database=login;uid=sa;pwd=;");
con.open();
SqlCommand cmd=new SqlComand("select count(*) from login where userName='"+userName+"' and userPwd='"+userPwd"');
int count=Conver.toInt32(cmd.Execute.Scalar());
表结构为
create table login
(
userName varchar(20) primary key;
userPwd varchar(20) not null;
userIdentity varchar(20);
}
如果用的是access数据库,怎么做啊,请指教相应的语句.
)

[ChengKing]

http://blog.csdn.net/chengking/archive/2005/10/14/504078.aspx

[amandag]

using System.data.OleDb;
OleDbConnection con=new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " + Application.StartupPath + "\\Exam.mdb");
con.open();
OleDbCommand cmd=new OleDbComand("select count(*) from login where userName='"+userName+"' and userPwd='"+userPwd"');
int count=Conver.toInt32(cmd.Execute.Scalar());

[cherishahu]

楼上的路径怎么设置啊,比如我的*.db文件为C:\user.db这样data source应该怎么写啊.

[cherishahu]

OleDBConnection conn = new OleDbconnection();
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\db2.mdb";
编译都出错,更不要说执行了.

[gezichong]

data source=C:\user.db

[nnh]

MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/data.mdb")

[aliketen]

public static readonly string conn_Default ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+HttpContext.Current.Request.PhysicalApplicationPath+ConfigurationSettings.AppSettings["ConDts"];

<add key="ConDts" value="DataBase\cbbs_db.mdb"/>

[smile9961]

string strConn = "provider=Microsoft.jet.oledb.4.0;Data source='E:\\DB\\orders.mdb';";
OleDbConnection conn = new OleDbConnection(strConn);
try {
conn.Open();
}
catch (Exception ex) {
Response.Write(ex.Message);
}
finally {
conn.Close();
}

[amandag]

conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\db2.mdb";

[MonkWang]

www.connectionstrings.com

[sunou5]

试试

OleDBConnection conn = new OleDbconnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\db2.mdb";