Codes
namespace MyProject
{
public partial class frmMyLogin : Form
{
public frmMyLogin()
{
InitializeComponent();
}
MySqlConnection con = new MySqlConnection(@"server=localhost;user id=root;database=employee");
MySqlDataAdapter da = new MySqlDataAdapter();
MySqlCommand cmd = new MySqlCommand();
private void btnLogin_Click(object sender, EventArgs e)
{
con.Open();
string Username = txtUsername.Text;
string Password = txtPassword.Text;
MySqlCommand cmd = new MySqlCommand("Select UserName,Password from login where UserName='"+txtUsername.Text+"'and Password='"+txtPassword.Text+"'",con);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Login Sucessfull");
frmMain mymain = new frmMain();
mymain.Show();
this.Hide();
}
else
{
MessageBox.Show("Invalid UserName or Password");
}
con.Close();
}
private void btnCancel_Click(object sender, EventArgs e)
{
DialogResult s = MessageBox.Show("Are you sure do you want to exit", "Exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (s == DialogResult.Yes)
{
Application.Exit();
}
}
private void btnNewUser_Click(object sender, EventArgs e)
{
string cmdText = "INSERT INTO login(UserName,Password) VALUES (@UserName, @Password)";
con.Open();
MySqlCommand cmd = new MySqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@UserName", txtUsername.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Create new user is successful");
con.Close();
}
}
}
------------
By Thissa
----------------
