asp.net操作access数据库基本方法

今天做个小项目，需要asp.net连接access，对其操作，本人经常使用sql server，但是操作access还是比较陌生，
只是以前上学的时候应用过，都忘完了，今天使用，然后上网搜了下资料，整理了一下，以备以后使用。

1、asp.net连接access数据库，方法有3中，看一下代码：


using System.Data.OleDb；
1）OleDbConnection conn = new OleDbConnection(ConfigurationManager.AppSettings["AccessConn"]);
2）public static string connectionString = “Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|test.mdb”;
3）OleDbConnection conn = new OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|test.mdb”)


2、基本操作：增删查改

aspx.cs

//获得数据集

GridView1.DataSource = mypub.GetDataSet(“select * from Messages”, “Messages”);
GridView1.DataBind();

mypub.ExecSql(“insert into Messages (Name,Email,Url,CTime) values (‘weixing’,'weixing@qq.com’,’https://www.weixing.me‘,’” + creatime + “‘) “).ToString();


pub.cs

public System.Data.DataSet GetDataSet(string sQueryString, string TableName) //返回结果集
{
OleDbConnection conn = new OleDbConnection(ConfigurationManager.AppSettings["AccessConn"]);
conn.Open();
OleDbDataAdapter dbAdapter = new OleDbDataAdapter(sQueryString,conn);
DataSet dataset = new DataSet();
dbAdapter.Fill(dataset, TableName);
conn.Close();
conn.Dispose();
return dataset;
}

public int ExecSql(string strsql) //返回值为影响的行数
{
OleDbConnection conn = new OleDbConnection(ConfigurationManager.AppSettings["AccessConn"]);
conn.Open();
OleDbCommand cmd = new OleDbCommand(strsql, conn);
int cmd_num = 0;
//执行成功
try
{
cmd_num=cmd.ExecuteNonQuery();
conn.Close();
conn.Dispose();
}
//执行失败
catch
{
conn.Close();
conn.Dispose();
return 0;
}
return cmd_num;
}

public string GetResult(string strsql)
{
OleDbConnection conn = new OleDbConnection(ConfigurationManager.AppSettings["AccessConn"]);
conn.Open();
OleDbCommand cmd = new OleDbCommand(strsql,conn);
string myresult = Convert.ToString(cmd.ExecuteScalar());
conn.Close();
conn.Dispose();
return myresult;
}