private void button1_Click(object sender, EventArgs e)
{
string student_name = textBox_student_name.Text;
string student_gender = textBox_gender.Text;
string student_address = textBox_student_address.Text;
string query = "insert into UMS_tbl_Students(Student_Name,Gender,Student_Address)VALUES('" + student_name + "','" + student_gender + "','" + student_address + "')";
using (DBhelper1 dbHelper = new DBhelper1())
{
dbHelper.ExecuteQuery(query);
}
LoadProductGridView();
}
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();
}
}