public int checklogin(ParentPrjs ck) { SqlCommand cmd = new SqlCommand("select * from tbl_Parent where ParentName=@username and Password=@password", con); cmd.CommandType = CommandType.Text; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@username", ck.parentname); cmd.Parameters.AddWithValue("@password", ck.password); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); ParentPrjs prt = null; int count = 0; if (sdr.Read()) { prt = new ParentPrjs { parentname = sdr[0].ToString(), password = sdr[1].ToString(), }; count++; } con.Close(); return(count); }
public void AddUserName(ParentPrjs pdetails) { SqlCommand cmd = new SqlCommand("insert into tbl_Parent values(@parentname,@pwd)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@parentname", pdetails.parentname); cmd.Parameters.AddWithValue("@pwd", pdetails.password); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
protected void Button1_Click(object sender, EventArgs e) { if (Page.IsValid == true) { Adoconnected dal = new Adoconnected(); ParentPrjs pdetalis = new ParentPrjs() { parentname = txtUsername.Text, password = txtPwd.Text }; dal.AddUserName(pdetalis); } lblMsg.Text = "Registered Successfully"; }
protected void Button1_Click(object sender, EventArgs e) { ParentPrjs prt = new ParentPrjs { parentname = txtName.Text, password = txtPwd.Text }; Adoconnected dal = new Adoconnected(); int count = dal.checklogin(prt); if (count > 0) { Response.Redirect("FourthPage.aspx"); } else { labelMsg.Text = "Invalid Username/Password"; } }