2.0中 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();