private void getdata() { string name = textBox1.Text; string pass = textBox2.Text; string adu = "admin"; da = new SqlDataAdapter("Select UserName FROM Person WHERE UserName like'" + textBox1.Text + "' and Password='******' ", con); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 1) { label5.Hide(); MessageBox.Show("Log in success"); Appbody obj = new Appbody(); this.Hide(); obj.Show(); } else if (name.Equals(adu) && pass.Equals(adu)) { label5.Hide(); MessageBox.Show("Successfully logged in as admin"); admin obj = new admin(); this.Hide(); obj.Show(); } else { label5.Show(); } }
private void button1_Click(object sender, EventArgs e) { try { connect obj = new connect(); obj.con.ConnectionString = obj.locate; obj.con.Open(); string insert = "insert into Person values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox9.Text + "','" + textBox8.Text + "','" + textBox7.Text + "','" + textBox6.Text + "','" + textBox10.Text + "')"; obj.cmd.Connection = obj.con; obj.cmd.CommandText = insert; obj.cmd.ExecuteNonQuery(); obj.con.Close(); MessageBox.Show("Sign up Completed"); this.Hide(); Appbody obj1 = new Appbody(); obj1.Show(); } catch (Exception ex) { MessageBox.Show("Error" + ex); } }