void LoadProductGridView() { dataGridView1.Rows.Clear(); string query = "select Student_ID,Student_Name,Gender,Student_Address from UMS_tbl_Students "; DataTable dt = new DataTable(); using (DBhelper1 dbHelper = new DBhelper1()) { dt = dbHelper.GetRecords(query); } foreach (DataRow row in dt.Rows) { dataGridView1.Rows.Add(row[0], row[1], row[2], row[3]); } }
private void Login_Click(object sender, EventArgs e) { string userName = textBox_user_name.Text; string password = textBox_password.Text; //Control.if empty or remove special charctaee string query = string.Format("select * from UMS_tbl_Users where Users='{0}' and Passwords='{1}'", userName, password); DataTable dt = new DataTable(); using (DBhelper1 dbhelper = new DBhelper1()) { dt = dbhelper.GetRecords(query); } if (dt.Rows.Count > 0) { Main frm = new Main(); frm.ShowDialog(); } }