private void btn_update_Click(object sender, EventArgs e) { con.Close(); phone = txt_phone.Text; email = txt_email.Text; //to call stored procedure SqlCommand cmd = new SqlCommand("edit_data", con); cmd.CommandType = CommandType.StoredProcedure; //pass value cmd.Parameters.AddWithValue("@phone", phone); cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@username", user); //exeute con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Data updated"); lbl_fullname uh = new lbl_fullname(); uh.ShowDialog(); }
private void btn_login_Click(object sender, EventArgs e) { username = txt_username.Text; u = username; password = txt_password.Text; if (username == "admin" && password == "admin") { Admin_home ahome = new Admin_home(); this.Hide(); ahome.Show(); } else { //sql coonection SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=productmanage;Integrated Security=true"); //to call stored procedure SqlCommand cmd = new SqlCommand("logindata", con); cmd.CommandType = CommandType.StoredProcedure; //pass values cmd.Parameters.AddWithValue("@username", username); cmd.Parameters.AddWithValue("@password", password); //execute stored procedure con.Open(); int i = (int)cmd.ExecuteScalar(); if (i > 0) { lbl_fullname ahom = new lbl_fullname(); this.Hide(); ahom.Show(); } else { MessageBox.Show("Invalid username&password"); } } }