//Admin a = new Admin(); //reg public int insert(signing s) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Desktop\Municipal management\Municipal management\Registration.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); SqlCommand cmd = new SqlCommand("insert into Reg (FirstName,LastName,UserName,Password,ConfirmPassword,MobileNo,DateofBirth,Gender)values('" + s.firstName + "','" + s.lastName + "','" + s.userName + "','" + s.password + "','" + s.confirmPassword + "','" + s.mobileNo + "','" + s.dob + "','" + s.gender + "')", con); try { return(cmd.ExecuteNonQuery()); } catch { con.Close(); throw; } }
//login public DataTable Select(signing s) { DataTable dt = new DataTable("Reg"); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Desktop\Municipal management\Municipal management\Registration.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); SqlCommand cmd = new SqlCommand("select * from Reg where UserName ='******' and Password ='******'", con); try { SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection); dt.Load(rd); return(dt); } catch { con.Close(); throw; } }
private void logIn_Click(object sender, EventArgs e) { signing s = new signing(); s.userName = userNameTextBox.Text; s.password = pswdTextbox.Text; Connection cn = new Connection(); DataTable dt = new DataTable(); dt = cn.Select(s); if (dt.Rows.Count > 0) { this.Hide(); welcome wel = new welcome(); wel.Show(); } else { MessageBox.Show("Invalid userName and Password"); } }