谢谢

解决方案 »

  1.   

    private void checkall(object sender, System.EventArgs e)

    if (box1.Text=="") { Page.RegisterStartupScript("messagebox","<script language=javascript>       alert ('请输入用户名!'); <"+"/"+"script>");return;}
    if (box2.Text=="") {Page.RegisterStartupScript("messagebox","<script language=javascript>       alert ('请输入密码!'); <"+"/"+"script>");return;}
    else
        {string Conn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("view.mdb")+";";
    OleDbConnection myconn=new OleDbConnection(Conn);
    myconn.Open();
        OleDbCommand cmd=new OleDbCommand("SELECT  *  FROM [user] WHERE username='"+box1.Text+"'",myconn);  
              OleDbDataReader reader=cmd.ExecuteReader(); 
    if(reader.Read())
    {
      if(box2.Text==Convert.ToString(reader["password"]))
                    
    {
            Session["level"]=reader["level"];
            Session["name"]=reader["name"];
            Session["password"]=reader["password"];
    Session["type"]=reader["type"];
    Session["jihuacaigou"]=box1.Text;
            reader.Close();
                myconn.Close() ;
                Response.Redirect("Index_New.asp");
                }

      else
                 {Page.RegisterStartupScript("messagebox","<script language=javascript>       alert ('用户名或密码不正确,请核对!'); <"+"/"+"script>");
                    reader.Close();
                    myconn.Close() ;return;
             }
     }
      else
                 {Page.RegisterStartupScript("messagebox","<script language=javascript>       alert ('用户名或密码不正确,请核对!'); <"+"/"+"script>");
                    reader.Close();
                    myconn.Close() ;return;
             }
    }
                
    }