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;
using MySql.Data;
namespace SimpleSerial
{
public partial class login : Form
{
public MySqlConnection con;
public MySqlCommand cmd;
public MySqlDataAdapter adapter;
DataTable dt = new DataTable();
public login()
{
InitializeComponent();
con = new MySqlConnection("Data Source=localhost;Initial Catalog=traffic_control;User=root;Integrated Security=false;pooling=false");
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
MySqlCommand cmd = new MySqlCommand();
string user, pass;
user = username.Text;
pass = passward.Text;
cmd.CommandText = "Select * from login where name=@user and password=@pass";
cmd.Parameters.AddWithValue("@user", user);
cmd.Parameters.AddWithValue("@pass", pass);
cmd.Connection = con;
MySqlDataReader login = cmd.ExecuteReader();
if (login.Read())
{
MessageBox.Show("login successfully");
panels panel = new panels();
panel.Show();
this.Hide();
}
else
{
MessageBox.Show("login Error");
con.Close();
}
}
}
}