private void btnlogin_Click(object sender, EventArgs e)
        {
            string ConnectionString = "Server=localhost;Database=test;Uid=root;Pwd=password;sslmode=none;";
            using (MySqlConnection con = new MySqlConnection(ConnectionString))
            {
                con.Open();
                using (MySqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandText = @"select count(*) from mysqlcsharp where UserName=@UserName and Password=@Password";
                    cmd.Parameters.Add(new MySqlParameter("UserName", txtuser.Text));
                    cmd.Parameters.Add(new MySqlParameter("Password", txtpass.Text));
                    int i = Convert.ToInt32(cmd.ExecuteScalar());
                    if (i > 0)
                    {
                        MessageBox.Show("UserName and Password correct.", "Succes!",MessageBoxButtons.OKCancel,MessageBoxIcon.Information);
                    }
                    else
                    {
                        MessageBox.Show("UserName or Password error.");
                    }
                }
            }
        }
    }
}