public void LoadData(DataTable tbl) { listgrid.RowCount = 0; listgrid.RowCount = tbl.Rows.Count; for (int r = 0; r < tbl.Rows.Count; r++) { DataGridViewRow row = listgrid.Rows[r]; row.Cells[DATABASES.DATABASES_ID].Value = tbl.Rows[r][DATABASES.DATABASES_ID]; row.Cells[DATABASES.DATABASES_NAME].Value = tbl.Rows[r][DATABASES.DATABASES_NAME]; row.Cells[DATABASES.NOTES].Value = tbl.Rows[r][DATABASES.NOTES]; row.Cells[DATABASES.ACTIVE_ID].Value = tbl.Rows[r][DATABASES.ACTIVE_ID]; row.Cells[DATABASES.USER_ID].Value = CUser_exten.GetName_Id(tbl.Rows[r][DATABASES.USER_ID].ToString()); } }
public void List_Option(ListOption pAction) { fAction = pAction; switch (fAction) { case ListOption.active: if (chk_notactive.Checked == true) { LoadData(CUser.TblData(CUser_exten.NotActive())); } else { LoadData(CUser.TblData(CUser_exten.Active())); } break; case ListOption.notactive: if (chk_notactive.Checked == true) { LoadData(CUser.TblData(CUser_exten.NotActive())); } else { LoadData(CUser.TblData(CUser_exten.Active())); } break; case ListOption.Search: if (txt_user_name.Text != "") { LoadData(CUser.TblData(CUser_exten.SearchName(txt_user_name.Text))); } else { LoadData(CUser.TblData(CUser_exten.Active())); } break; default: LoadData(CUser.TblData(CUser_exten.Active())); break; } }
public void LoadData(DataTable tbl) { listgrid.RowCount = 0; listgrid.RowCount = tbl.Rows.Count; for (int r = 0; r < tbl.Rows.Count; r++) { DataGridViewRow row = listgrid.Rows[r]; row.Cells[SERVERS.SERVERS_ID].Value = tbl.Rows[r][SERVERS.SERVERS_ID]; row.Cells[SERVERS.SERVERS_NAME].Value = tbl.Rows[r][SERVERS.SERVERS_NAME]; row.Cells[SERVERS.SERVERS_VERSION].Value = tbl.Rows[r][SERVERS.SERVERS_VERSION]; row.Cells[SERVERS.SERVERS_PATH].Value = tbl.Rows[r][SERVERS.SERVERS_PATH]; row.Cells[SERVERS.SERVERS_BACKUP_PATH].Value = tbl.Rows[r][SERVERS.SERVERS_BACKUP_PATH]; row.Cells[SERVERS.NOTES].Value = tbl.Rows[r][SERVERS.NOTES]; row.Cells[SERVERS.ACTIVE_ID].Value = tbl.Rows[r][SERVERS.ACTIVE_ID]; row.Cells[SERVERS.USER_ID].Value = CUser_exten.GetName_Id(tbl.Rows[r][SERVERS.USER_ID].ToString()); } }
public void LoadData(DataTable tbl) { listgrid.RowCount = 0; listgrid.RowCount = tbl.Rows.Count; for (int r = 0; r < tbl.Rows.Count; r++) { DataGridViewRow row = listgrid.Rows[r]; row.Cells[USER.USER_ID].Value = tbl.Rows[r][USER.USER_ID]; row.Cells[USER.USER_NAME].Value = tbl.Rows[r][USER.USER_NAME]; row.Cells[USER.USER_PASSWORD].Value = tbl.Rows[r][USER.USER_PASSWORD]; row.Cells[USER.CREATEON].Value = tbl.Rows[r][USER.CREATEON]; row.Cells[USER.ENTRYBY].Value = tbl.Rows[r][USER.ENTRYBY]; row.Cells[USER.NOTES].Value = tbl.Rows[r][USER.NOTES]; row.Cells[USER.ACTIVE_ID].Value = tbl.Rows[r][USER.ACTIVE_ID]; row.Cells[USER.USER_ID].Value = CUser_exten.GetName_Id(tbl.Rows[r][USER.USER_ID].ToString()); } }
public void SetAction(BtnEvent pAction, string pPkValue) { fAction = pAction; switch (fAction) { case BtnEvent.Open: btn_save.Text = "CLOSE"; obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue)); this.EnableControls(false); break; case BtnEvent.New: btn_save.Text = "SAVE"; obj = new User(); this.EnableControls(true); break; case BtnEvent.Edit: btn_save.Text = "UPDATE"; obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue)); this.EnableControls(true); break; case BtnEvent.Delete: btn_save.Text = "CONFIRM\r\nDELETE"; obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue)); this.EnableControls(false); break; case BtnEvent.Print: btn_save.Text = "PRINT"; obj = CUser.PropertiesData(CUser_exten.PKId(pPkValue)); this.EnableControls(false); break; } this.LoadData(); }
void txt_user_LookupUpdate(object sender, EventArgs e) { txt_user_name.LookupList = CUser_exten.GetforLookup(); }