private void button1_Click(object sender, EventArgs e) { { var data = DBconnection.gettablebyquery("Select * from userid where UserName='******' and Password='******'"); if (data.Rows.Count > 0) { CommonInfo.UserId = (int)data.Rows[0]["UserId"]; CommonInfo.StaffName = data.Rows[0]["StaffName"].ToString(); CommonInfo.Email = data.Rows[0]["Email"].ToString(); CommonInfo.UserName = data.Rows[0]["UserName"].ToString(); CommonInfo.Password = txtpswrd.Text; CommonInfo.Telephone = data.Rows[0]["Telephone"].ToString(); mainform mf = new mainform(); mf.ShowDialog(); } else { MessageBox.Show("username password doesnot match ."); txtpswrd.Focus(); txtpswrd.SelectAll(); //password error message } } }
private void Loadbankentry() { //query to select data fron Bankentry string sql = "select * from bankentry "; var dataList = DBconnection.gettablebyquery(sql); dataGridbankentry.DataSource = dataList; }
private void dateTimeentry_ValueChanged(object sender, EventArgs e) { try { string sql = "select * from chequeentry "; var dataList = DBconnection.gettablebyquery(sql); dataGridchequeentry.DataSource = dataList; } catch (Exception) { throw; } }