OleDB
libraries
using System.Data.OleDb;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application .StartupPath + "\\logindb.accdb"); OleDbCommand cmd; OleDbDataAdapter da; DataTable dt; string sql;
private int login(string sql) { int maxrow = 0; try { con.Open(); cmd.Connection = con; cmd.CommandText = sql; da.SelectCommand = cmd; da.Fill(dt); maxrow = dt.Rows.Count; } catch(Exception ex) { MessageBox.Show ( ex.Message); } finally { da.Dispose(); con.Close(); } return maxrow; }
private void button1_Click(object sender, EventArgs e) { int maxrow = 0; sql = "Select * From tbluser WHERE u_name = '" + textBox1.Text + "' AND u_pass='" + textBox2.Text + "'"; maxrow = login(sql); if(maxrow > 0) { MessageBox.Show("Welcome User"); groupBox1.Enabled = false; label3.Text = "Welcome " + dt.Rows[0].Field<string>("fullname") + " | Logout" ; textBox1.Clear(); textBox2.Clear(); } else { MessageBox.Show("Your username and Password is incorrect.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void label3_Click(object sender, EventArgs e) { groupBox1.Enabled = true; label3.Text = "Login System"; }