private void db_connection()
        {
            try
            {
                conn = "Server=remotemysql.com;Database=VPEoiEQ0oT;Uid=VPEoiEQ0oT;Pwd=2gicrsN3fU;";
                connect = new MySqlConnection(conn);
                connect.Open();
            }
            catch (MySqlException e)
            {
                throw;
            }
        }
        private bool validate_login(string user, string pass)
        {
            db_connection();
            MySqlCommand cmd = new MySqlCommand();
            cmd.CommandText = "Select * from table2 where username=@user and password=@pass";
            cmd.Parameters.AddWithValue("@user", user);
            cmd.Parameters.AddWithValue("@pass", pass);


            cmd.Connection = connect;
            MySqlDataReader login = cmd.ExecuteReader();
            if (login.Read())
            {
                connect.Close();
                return true;
            }
            else
            {
                connect.Close();
                return false;
            }
        }



        private void button1_Click(object sender, EventArgs e)
        {
            {
                string user = username.Text;
                string pass = password.Text;


                if (user == "" || pass == "")
                {
                    MessageBox.Show("Empty Fields Detected ! Please fill up all the fields");
                    return;
                }
                bool r = validate_login(user, pass);
                if (r)

                {
                    conn = "Server=remotemysql.com;Database=VPEoiEQ0oT;Uid=VPEoiEQ0oT;Pwd=2gicrsN3fU;";
                    connect = new MySqlConnection(conn);

                    connect.Open();

                    SqlCommand command = new SqlCommand("Select UserID from table2 where username=@user");
                    command.Parameters.AddWithValue("@user", "username");
                    // int result = command.ExecuteNonQuery();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            Console.WriteLine(String.Format("{0}", reader["UserID"]));

                        }
                    }

                    connect.Close();
                }

                {
                        Form1 f1 = new Form1();
                        this.Hide();
                        var form1 = new Form1();
                        form1.Closed += (s, args) => this.Close();
                        form1.Show();
                 }


                }
        }