protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         obj.User_name = TextBox1.Text;
         obj.Password  = TextBox2.Text;
         SqlDataReader dr = obj.UserLogin();
         if (dr.Read())
         {
             obj.User_name    = TextBox1.Text;
             obj.Password     = TextBox2.Text;
             obj.New_Password = TextBox3.Text;
             int i = obj.changepass();
             if (i > 0)
             {
                 Label1.Text = "Password Changed Successfull ....";
                 ClearFields();
             }
             else
             {
                 Label1.Text = "Password Changing Failed Try Again ......";
             }
         }
         else
         {
             Label1.Text = "Invalid User name And Password..";
         }
     }
     catch (Exception ex)
     {
         Label1.Text = ex.Message;
     }
 }
 protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (TextBox1.Text != null)
         {
             obj.User_name = TextBox1.Text;
             obj.Password  = TextBox2.Text;
             SqlDataReader dr = obj.UserLogin();
             if (dr.Read())
             {
                 if (dr["Roll"].ToString().ToUpper() == "USER")
                 {
                     Session["User"]     = dr["Id"].ToString();
                     Session["UserName"] = TextBox1.Text;
                     Response.Redirect("Student/Default.aspx");
                 }
                 else if (dr["Roll"].ToString().ToUpper() == "ADMIN")
                 {
                     Session["Admin"]     = dr["Id"].ToString();
                     Session["AdminName"] = TextBox1.Text;
                     Response.Redirect("Admin/Default.aspx");
                 }
                 else
                 {
                     Label1.Text = "Invalid User Or Admin";
                 }
             }
             else
             {
                 Label1.Text = "Invalid User Or Admin";
             }
         }
     }
     catch (Exception ex)
     {
         Label1.Text = ex.Message;
     }
 }