private void fCRManage_Load(object sender, EventArgs e) { this.grMain.DataSource = bs; string sql = "select * from dmlydo"; tblydo = _db.GetDataTable(sql); this.riLydo.DataSource = tblydo; gvMain.CustomDrawCell += new DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventHandler(gvMain_CustomDrawCell); }
private void GetLoad() { tbCr = db.GetDataTable("select Tk,MaWC,MaSP,Inload from plwc where 1=0"); for (int i = minTk; i <= maxTk; i++) { foreach (DataRow dr in MasterTb.Rows) { if (dr["Tk" + i.ToString()] != DBNull.Value && double.Parse(dr["Tk" + i.ToString()].ToString()) > 0) { DataRow _r = tbCr.NewRow(); _r["Tk"] = i.ToString(); _r["MaWC"] = dr["MaWC"]; _r["MaSP"] = dr["MaSP"]; _r["Inload"] = double.Parse(dr["Tk" + i.ToString()].ToString()); tbCr.Rows.Add(_r); } } } }
private void fSelectTask4Copy_Load(object sender, EventArgs e) { string sql = "select a.ID, a.TaskLabel, b.WFName, c.TableName, c.DienGiai from systask a " + " inner join sysWF b on a.WFID = b.ID " + " inner join systable c on b.systableid = c.systableid"; tbTask = dbStruct.GetDataTable(sql); bs.DataSource = tbTask; gridControl2.DataSource = bs; bs.CurrentItemChanged += Bs_CurrentItemChanged; }
private void Filter_Load(object sender, EventArgs e) { string sql = "select * from dmnhomgt"; DataTable tb = dt.GetDataTable(sql); //MessageBox.Show(tb.Rows.Count.ToString()); gridLookUpEdit1.Properties.DataSource = tb; gridLookUpEdit1.Properties.ValueMember = "MaNhom"; gridLookUpEdit1.Properties.DisplayMember = "TenNhom"; if (tb.Rows.Count > 0) { gridLookUpEdit1.Select(0, 1); } }
private void Filter_Load(object sender, EventArgs e) { string sql = "select * from dmnhomgt"; DataTable tb = dt.GetDataTable(sql); gridLookUpEdit1.Properties.DataSource = tb; gridLookUpEdit1.Properties.ValueMember = "MaNhom"; gridLookUpEdit1.Properties.DisplayMember = "TenNhom"; gridLookUpEdit1.EditValue = manhom; gridLookUpEdit1.Properties.ReadOnly = true; spinEdit1.EditValue = Config.GetValue("KyKeToan") == null ? DateTime.Today.Month : Int32.Parse(Config.GetValue("KyKeToan").ToString()); spinEdit2.EditValue = Config.GetValue("KyKeToan") == null ? DateTime.Today.Month : Int32.Parse(Config.GetValue("KyKeToan").ToString()); if (Config.GetValue("Language").ToString() == "1") { FormFactory.DevLocalizer.Translate(this); } }
private void getSohieu() { string sql = "select * from dmImation"; gridLookUpEdit1.Properties.DataSource = db.GetDataTable(sql); }