public DataSet getIconChild() { string query = "SELECT DuongDanAnh, MaDonVi FROM dbo.DonVi"; DataSet dataSet = new DataSet(); connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.Text); return(dataSet); }
public DataSet getDataParentNode() { string query = "SELECT * FROM dbo.BinhChung"; DataSet dataSet = new DataSet(); connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.Text); return(dataSet); }
public void getDataTSDV(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit) { string query = "LayThongTinThamSoDauVao"; DataSet dataSet = new DataSet(); connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.StoredProcedure); dataGridView.DataSource = dataSet.Tables[0]; searchLookUpEdit.Properties.DataSource = dataSet.Tables[0]; }
public void SelectSuCoWithKeHoach(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit, int maKeHoach) { connection connect; string query = "SelectSuCoWithIDKeHoach "; DataSet dataSet = new DataSet(); connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.StoredProcedure, new [] { "maKeHoach" }, new object[] { maKeHoach }); dataGridView.DataSource = dataSet.Tables[0]; searchLookUpEdit.Properties.DataSource = dataSet.Tables[0]; }
public void SelectAllSuCo(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit) { connection connect; string query = "SelectAllSuCo"; DataSet dataSet = new DataSet(); connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.StoredProcedure); dataGridView.DataSource = dataSet.Tables[0]; searchLookUpEdit.Properties.DataSource = dataSet.Tables[0]; }
public DataSet getDataChildNode(string mabinhchung) { string query = "LayTTDonViTheoBinhChung"; string[] para = { "@mabinhchung" }; string[] value = { mabinhchung }; DataSet dataSet = new DataSet(); connection connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.StoredProcedure, para, value); return(dataSet); }
public List <Dem> SelectAllFileDem() { connection connect; string query = "SelectAllFile"; DataSet dataSet = new DataSet(); connect = new connection(); dataSet = connect.FillDataSet(query, CommandType.StoredProcedure); List <Dem> list = new List <Dem>(); foreach (DataRow row in dataSet.Tables[0].Rows) { list.Add(new Dem() { MaFile = row.Field <int>((int)FileDemField.MaFile), TenFile = row.Field <string>((int)FileDemField.TenFile), DuongDan = row.Field <string>((int)FileDemField.DuongDan) }); } return(list); }