using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace SampleProject
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


        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.");
                    }
                }
            }
        }
    }
}