using System.Data;
using System.Data.OleDb;
OleDbConnection thisConnection = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("data.mdb"));//获取本地Access
//数据库路径
thisConnection.Open();
string strCom = "select * from account where uid = '" + strUid + "' and pwd = '" + strPwd + "'";
OleDbCommand thisCommand = new OleDbCommand(strCom,thisConnection);
thisCommand.ExecuteReader(); 或者 thisCommand.ExecuteNonQuery();
(这两句都可以执行sql语句)