连接并查询Access2003数据库

最新推荐文章于 2024-02-21 09:28:44 发布

panpanguo

最新推荐文章于 2024-02-21 09:28:44 发布

阅读量2k

点赞数

文章标签： access 数据库 string sql object cmd

本文链接：https://blog.csdn.net/panpanguo/article/details/6107818

版权

#region 连接并查询Access2003数据库

/// <summary> #region 连接并查询Access2003数据库 /// <summary> /// 连接并查询Access2003数据库 /// </summary> protected void btnAccess2003_Click(object sender, EventArgs e) { string connStr = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|//Access2003.mdb"; OleDbConnection conn = new OleDbConnection(connStr); try { conn.Open(); lblAccess2003.Text = "成功打开Access2003数据库！"; string sql = "select * from UserInfo where UserName='abc'"; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) dr.Read(); lblAccess2003.Text += "--并且成功读取第1条记录：UserNaem=" + dr["UserName"] + " Pwd=" + dr["Pwd"].ToString(); } catch (OleDbException ex) { lblAccess2003.Text = "打开Access2003数据库文件失败！"; Response.Write("----------------------------------------------------------------------------------------- " + ex.StackTrace + " ---------------------------------------------------------------------------------------------- "); } finally { if (conn.State == ConnectionState.Open) conn.Close(); } } #endregion #region 连接并查询Access2007数据库 /// <summary> /// 连接并查询Access2007数据库 /// </summary> protected void btnAccess2007_Click(object sender, EventArgs e) { string connStr = "provider=Microsoft.Ace.Oledb.12.0;Data Source=|DataDirectory|//Access2007.accdb"; OleDbConnection conn = new OleDbConnection(connStr); try { conn.Open(); lblAccess2007.Text = "成功打开Access2007数据库！"; string sql = "select * from UserInfo where UserName='abc'"; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); lblAccess2007.Text += "--并且成功读取第1条记录：UserNaem=" + dr["UserName"] + " Pwd=" + dr["Pwd"].ToString(); } else { lblAccess2007.Text += "--但没有读取到任何数据！"; } } catch (OleDbException ex) { lblAccess2007.Text = "打开Access2007数据库文件失败！"; Response.Write("----------------------------------------------------------------------------------------- " + ex.StackTrace + " ---------------------------------------------------------------------------------------------- "); } finally { if (conn.State == ConnectionState.Open) conn.Close(); } } #endregion

/// 连接并查询Access2003数据库

/// </summary>

protected void btnAccess2003_Click(object sender, EventArgs e)

{

string connStr = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|//Access2003.mdb";

OleDbConnection conn = new OleDbConnection(connStr);

try

{

conn.Open();

lblAccess2003.Text = "成功打开Access2003数据库！";

string sql = "select * from UserInfo where UserName='abc'";

OleDbCommand cmd = new OleDbCommand(sql, conn);