//Open ViewAll Form
        private void button1_Click(object sender, EventArgs e)
        {
            this.Hide();
            ViewAll fm = new ViewAll();

            fm.Show();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            i = 0;
            con.Open();
            MySqlCommand cmd = con.CreateCommand();

            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "SELECT * FROM admin where username ='******' and password='******'";
            cmd.ExecuteNonQuery();

            DataTable        dt = new DataTable();
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            da.Fill(dt);
            i = Convert.ToInt32(dt.Rows.Count.ToString());

            if (i != 0)
            {
                this.Hide();
                ViewAll fm = new ViewAll();
                fm.Show();
            }

            else
            {
                MessageBox.Show("Invalid Email or password");
                textBox1.Text = "";
                textBox2.Text = "";
            }

            con.Close();
        }