public DataSet.DsPSMS.ST_STAFF_DATADataTable getAllStaffData(out string msg) { DataSet.DsPSMS.ST_STAFF_DATADataTable result = new DataSet.DsPSMS.ST_STAFF_DATADataTable(); try { salaryDB.Open(); result = salaryDB.selectAllStaffData(); if (result != null && result.Rows.Count > 0) { msg = result.Rows.Count + " user found"; } else { result = null; msg = "user not found"; } } catch { msg = "error has occure when insert data"; return(null); } finally { salaryDB.Close(); } return(result); }
public DataSet.DsPSMS.ST_STAFF_DATADataTable selectAllStaffData() { string query = "SELECT * FROM ST_STAFF_DATA ORDER BY STAFF_ID"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_STAFF_DATADataTable dt = new DataSet.DsPSMS.ST_STAFF_DATADataTable(); da.Fill(dt); return(dt); }
public DataSet.DsPSMS.ST_STAFF_DATARow selectStaffByid(int id) { //conn.Open(); string query = "SELECT * FROM ST_STAFF_DATA WHERE STAFF_ID=" + id; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_STAFF_DATADataTable dt = new DataSet.DsPSMS.ST_STAFF_DATADataTable(); da.Fill(dt); //return single row return(dt[0]); }
private void displayStaffData() { DataSet.DsPSMS.ST_STAFF_DATADataTable staffs = salarySerivce.getAllStaffData(out msg); if (gvsalarylist.Columns.Count == 9) { gvsalarylist.Columns.Remove(gvsalarylist.Columns[8]); } if (staffs != null) { gvsalarylist.DataSource = staffs; ((BoundField)gvsalarylist.Columns[0]).DataField = "STAFF_ID"; ((BoundField)gvsalarylist.Columns[1]).DataField = "STAFF_NAME"; ((BoundField)gvsalarylist.Columns[2]).DataField = "SALARY"; gvsalarylist.DataBind(); } }
public DataSet.DsPSMS.ST_STAFF_DATARow getStaffIdByid(int id) { DataSet.DsPSMS.ST_STAFF_DATARow resultData = new DataSet.DsPSMS.ST_STAFF_DATADataTable().NewST_STAFF_DATARow(); try { salaryDB.Open(); resultData = salaryDB.selectStaffByid(id); } catch { return(null); } finally { salaryDB.Close(); } return(resultData); }