2.0中 Access数据库连接

Access数据库登录

最新推荐文章于 2025-12-03 18:58:29 发布

最新推荐文章于 2025-12-03 18:58:29 发布 · 121 阅读

文章标签：

#数据库

本文介绍两种使用Access数据库进行用户验证的方法。一种是在配置文件中直接指定数据库路径，另一种是通过配置文件间接引用数据库路径。每种方法都提供了具体的代码示例。

方案<一>
配置文件中:
<connectionStrings>
 <add name="StrData" connectionString="App_Data/movie.mdb"/> </connectionStrings> 
代码调用:
string ACConnectionString = "Provider = Microsoft.Jet.OleDb.4.0; Data Source = " + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["StrData"].ConnectionString); OleDbConnection conn = new OleDbConnection(ACConnectionString); conn.Open(); string sql = "select * from USERS where uname='" + TxtName.Text + "' and pass='" + TxtPwd.Text + "' "; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Response.Redirect("reg.aspx"); } else { Response.Write("Roung"); } conn.Close();
方案<二>
配置文件中:
<connectionStrings> <add name="StrData" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source =C:/Documents and Settings/SupperSdr/My Documents/Visual Studio 2005/WebSites/流媒体/App_Data/movie.mdb" providerName="System.Data.OleDb"/> </connectionStrings>
代码调用:
OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["StrData"].ConnectionString ); conn.Open(); string sql = "select * from USERS where uname='" + TxtName.Text + "' and pass='"+ TxtPwd.Text +"' "; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader (); if (dr.Read()) { Response.Redirect("reg.aspx"); } else { Response.Write("Roung"); } conn.Close();