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 ah = new Admin_home();
                this.Hide();
                ah.Show();
            }
            else
            {
                //sql connection
                SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Product_Management;Integrated Security=true");

                //to call stored procedure

                SqlCommand cmd = new SqlCommand("login_data", con);
                cmd.CommandType = CommandType.StoredProcedure;

                //pass the value to the stored procedure
                cmd.Parameters.AddWithValue("@username", username);
                cmd.Parameters.AddWithValue("@password", password);

                //execute stored procedure
                con.Open();
                int i = (int)cmd.ExecuteScalar();
                if (i > 0)
                {
                    User_home uh = new User_home();
                    this.Hide();
                    uh.Show();
                }
                else
                {
                    MessageBox.Show("Invalid username & password");
                }
            }
        }
        private void btn_update_Click(object sender, EventArgs e)
        {
            con.Close();
            email           = txt_email.Text;
            phone           = txt_phone.Text;
            cmd             = new SqlCommand("update_data", con);
            cmd.CommandType = CommandType.StoredProcedure;
            //to pass values to the stored procedure
            cmd.Parameters.AddWithValue("@username", user);
            cmd.Parameters.AddWithValue("@email", email);
            cmd.Parameters.AddWithValue("@phone", phone);
            //execute stored procedure
            con.Open();
            cmd.ExecuteNonQuery();
            MessageBox.Show("Data updated");
            User_home uh = new User_home();

            //this.Hide();
            uh.ShowDialog();
        }