?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class lpgin : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string username = Request.Form["UserName"].ToString();
        //string userpwd = Request.Form["UserPwd"].ToString();
        string userpwd = Request.Form.Get("UserPwd").ToString();

        OleDbConnection con = DB.creatConnection();
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select * from UserTable where UserName='"+username+"' and UserPwd='"+userpwd+"'",con);
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        if (count>0)
        {
            Response.Redirect("index.htm");  
        }
        else
        {
            Response.Redirect("loginFile.aspx");
        }

    }
}