private void button1_Click(object sender, EventArgs e) { { if (txtbox_username.Text != "" && txtbox_password.Text != "") { SqlConnection con = new SqlConnection(constring); con.Open(); string sql = "select * from User_detail where username =@user and password =@pass"; SqlCommand cmd = new SqlCommand(sql, con); byte[] pass = System.Text.Encoding.UTF8.GetBytes(txtbox_password.Text.ToString()); cmd.Parameters.AddWithValue("@user", txtbox_username.Text); cmd.Parameters.AddWithValue("@pass", Md5hash(pass)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); con.Close(); da.Fill(ds, "checkuser"); if (ds.Tables["checkuser"].Rows.Count == 1) { usrid(); /// to get userid con.Open(); SqlDataReader dr1 = cmd.ExecuteReader(); if (dr1.Read()) { string usrtyp = (dr1["usertype"].ToString()); if (usrtyp == "Admin") { MessageBox.Show("WELCOME TO ADMINISTRATOR PANEL"); this.Hide(); admin.Administrator_Dasboard adm = new admin.Administrator_Dasboard(id); adm.Show(); } else { MessageBox.Show("WELCOME TO EMPLOYEE PANEL"); this.Hide(); emp.Employee_dash employeedash = new emp.Employee_dash(id); employeedash.Show(); } } con.Close(); } else { MessageBox.Show("User Not Found"); } } else { MessageBox.Show("You must fill credential to login!"); } } }
private void Start_Load(object sender, EventArgs e) { admin.Administrator_Dasboard bla = new admin.Administrator_Dasboard(); bla.Show(); }