vs2005 连接ACCESS代码

来源:互联网 发布:淘宝头条问答 编辑:程序博客网 时间:2024/05/21 17:48

         string username = Request["username"].ToString();
        string password = Request["password"].ToString();

        string DBPath = Server.MapPath("testdb.mdb");
        OleDbConnection dbcon = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + DBPath + "");
        dbcon.Open();

        OleDbCommand ocmd = new OleDbCommand("select count(*) from login where username='+username+' and password='+password+'", dbcon);
        int count = Convert.ToInt32(ocmd.ExecuteScalar());

        if (count < 0)
        {
            Response.Redirect("main.aspx");
        }
        else
        {
            Response.Write("error");
        }

给自己建备忘录

原创粉丝点击