protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e) { //是查询 if (isSearch.Text == "1") { hiddenplat.Text = comboxPlats.SelectedItem.Value; hiddensoft.Text = comboxSofts.SelectedItem.Value; hiddenversion.Text = txtversion.Text.Trim(); var list = Sjqd_SoftVersionsService.GetSoftVersions(Convert.ToInt32(hiddensoft.Text), Convert.ToInt32(hiddenplat.Text), hiddenversion.Text); Store3.DataSource = list.Take(this.pagecut.PageSize + 1); Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = list.Count(); isSearch.Text = "0"; } else { int PageSize = this.pagecut.PageSize; int IndexSize = e.Start; if (IndexSize == -1) { IndexSize = 0; } var list = Sjqd_SoftVersionsService.GetSoftVersions(Convert.ToInt32(hiddensoft.Text), Convert.ToInt32(hiddenplat.Text), hiddenversion.Text); Store3.DataSource = list.Skip(IndexSize).Take(PageSize); Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = list.Count(); } }
private void data_Bind() { //项目数据 var projectList = XMProjectService.GetXMProjectList(); Store2.DataSource = projectList; Store2.DataBind(); //发货点数据(发货仓) var codeList = CodeService.GetCodeListInfoByCodeTypeID(227); Store3.DataSource = codeList; Store3.DataBind(); //省份数据 var provinceList = AreaCodeService.GetAreaCodeByRank(2); Store4.DataSource = provinceList; Store4.DataBind(); //物流公司数据 var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(243); Store7.DataSource = logisticsList; Store7.DataBind(); }
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e) { int count = 0; hiddenplat.Text = comboxPlats.SelectedItem.Value; hiddensbxh.Text = txtsbxh.Text.Trim(); hiddensbxhname.Text = txtsbxhname.Text.Trim(); ///是查询 if (isSearch.Text == "1") { var list = Sjqd_SBXHService.GetSjqd_SBXHList(Convert.ToInt32(hiddenplat.Text), hiddensbxhname.Text, hiddensbxh.Text, 0, pagecut.PageSize + 1, out count); Store3.DataSource = list; Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = count; isSearch.Text = "0"; } else { int PageSize = this.pagecut.PageSize; int IndexSize = e.Start; if (IndexSize == -1) { IndexSize = 0; } var list = Sjqd_SBXHService.GetSjqd_SBXHList(Convert.ToInt32(hiddenplat.Text), hiddensbxhname.Text, hiddensbxh.Text, IndexSize, pagecut.PageSize, out count); Store3.DataSource = list; Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = count; } }
public void PYchange(string py, string store) { string oracletext = "select * from M_OBJECT where RISK_TYPESID = 8 and MO_F_PINYIN like '%" + py.ToUpper() + "%'"; switch (store) { case "Store1": string oracletext1 = "select * from M_OBJECT where RISK_TYPESID = " + extRISK_TYPESNUMBER.SelectedItem.Value.Trim() + " and MO_F_PINYIN like '%" + py.ToUpper() + "%'"; Store1.DataSource = OracleHelper.Query(oracletext1); Store1.DataBind(); break; case "Store2": Store2.DataSource = OracleHelper.Query(oracletext); Store2.DataBind(); break; case "Store3": Store3.DataSource = OracleHelper.Query(oracletext); Store3.DataBind(); break; case "Store4": Store4.DataSource = OracleHelper.Query(oracletext); Store4.DataBind(); break; } }
private void BindCombox() { DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>() { dal.CreateIFields().Append("Option", "PrintForStat") }).GetTable(); if (dt != null && dt.Rows.Count > 0) { Store2.DataSource = dt; Store2.DataBind(); } DataTable dt1 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>() { dal.CreateIFields().Append("Option", "PrintForSys") }).GetTable(); if (dt1 != null && dt1.Rows.Count > 0) { Store3.DataSource = dt1; Store3.DataBind(); } DataSet dt2 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>() { dal.CreateIFields().Append("Option", "PrinterForPrinter") }).GetList(); StorePrinter.DataSource = dt2; StorePrinter.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string fechaInicio, fechaFin; if (DateField1.Text == "" || DateField1.Text == "01/01/0001 12:00:00 a.m.") { fechaInicio = ""; } else { fechaInicio = Convert.ToDateTime(DateField1.Text).ToString("yyyy-MM-dd"); } if (DateField2.Text == "" || DateField2.Text == "01/01/0001 12:00:00 a.m.") { fechaFin = ""; } else { fechaFin = Convert.ToDateTime(DateField2.Text).ToString("yyyy-MM-dd"); } wsConsultaReportesDA.wsConsultaReportesDA reportegral = new wsConsultaReportesDA.wsConsultaReportesDA(); List <wsConsultaReportesDA.ReporteSiniestrosDA> lista = new List <wsConsultaReportesDA.ReporteSiniestrosDA>(reportegral.ReporteSiniestros(1, fechaInicio, fechaFin, 9)); //indicadores.wsIndicadoresPrybe indica = new indicadores.wsIndicadoresPrybe(); //List<indicadores.CoopAseg> lista = new List<indicadores.CoopAseg>(indica.CotizacionesPorCoopAseg(fechaInicio, fechaFin)); //Store1.DataSource = lista; //Store1.DataBind(); Store3.DataSource = lista; Store3.DataBind(); }
protected void FillTimeApproval(int dayId, int employeeId) { try { string rep_params = ""; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("1", employeeId.ToString()); parameters.Add("2", dayId.ToString()); parameters.Add("3", dayId.ToString()); parameters.Add("4", "0"); parameters.Add("5", "0"); parameters.Add("6", "0"); parameters.Add("7", "0"); parameters.Add("8", "0"); parameters.Add("9", "0"); parameters.Add("10", "0"); foreach (KeyValuePair <string, string> entry in parameters) { rep_params += entry.Key.ToString() + "|" + entry.Value + "^"; } if (rep_params.Length > 0) { if (rep_params[rep_params.Length - 1] == '^') { rep_params = rep_params.Remove(rep_params.Length - 1); } } ReportGenericRequest req = new ReportGenericRequest(); req.paramString = rep_params; ListResponse <Time> Times = _timeAttendanceService.ChildGetAll <Time>(req); timeCode = ConstTimeVariationType.TimeCodeList(_systemService); if (!Times.Success) { Common.errorMessage(Times); return; } Times.Items.ForEach(x => { x.timeCodeString = timeCode.Where(y => y.key == Convert.ToInt16(x.timeCode)).Count() != 0 ? timeCode.Where(y => y.key == Convert.ToInt32(x.timeCode)).First().value : string.Empty; x.statusString = FillApprovalStatus(x.status); }); Store3.DataSource = Times.Items; ////List<ActiveLeave> leaves = new List<ActiveLeave>(); //leaves.Add(new ActiveLeave() { destination = "dc", employeeId = 8, employeeName = new Model.Employees.Profile.EmployeeName() { fullName = "vima" }, endDate = DateTime.Now.AddDays(10) }); Store3.DataBind(); } catch (Exception exp) { X.Msg.Alert(Resources.Common.Error, exp.Message).Show(); } }
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e) { int count = 0; ///是查询 if (isSearch.Text == "1") { hiddenlan.Text = txtlan.Text.Trim(); hiddenlanname.Text = txtlanname.Text.Trim(); var list = Sjqd_CpuService.GetSjqd_LanList(hiddenlan.Text, hiddenlanname.Text, 0, pagecut.PageSize, out count); Store3.DataSource = list; Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = count; isSearch.Text = "0"; } else { int PageSize = this.pagecut.PageSize; int IndexSize = e.Start; if (IndexSize == -1) { IndexSize = 0; } var list = Sjqd_CpuService.GetSjqd_LanList(hiddenlan.Text, hiddenlanname.Text, IndexSize, pagecut.PageSize, out count); Store3.DataSource = list; Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = count; } }
protected void documentsStore_ReadData(object sender, StoreReadDataEventArgs e) { //GEtting the filter from the page string filter = string.Empty; int totalCount = 1; //Fetching the corresponding list //in this test will take a list of News DocumentListRequest request = new DocumentListRequest(); request.Status = 0; request.Filter = ""; ListResponse <AdminDocument> routers = _administrationService.ChildGetAll <AdminDocument>(request); if (!routers.Success) { Common.errorMessage(routers); return; } if (!string.IsNullOrEmpty(DeptId1.Text)) { Store1.DataSource = routers.Items.Where(x => x.departmentId == DeptId1.Text); Store1.DataBind(); } if (!string.IsNullOrEmpty(DeptId2.Text)) { Store2.DataSource = routers.Items.Where(x => x.departmentId == DeptId2.Text); Store2.DataBind(); } if (!string.IsNullOrEmpty(DeptId3.Text)) { Store3.DataSource = routers.Items.Where(x => x.departmentId == DeptId3.Text); Store3.DataBind(); } if (!string.IsNullOrEmpty(DeptId4.Text)) { Store3.DataSource = routers.Items.Where(x => x.departmentId == DeptId4.Text); Store4.DataBind(); } if (!string.IsNullOrEmpty(DeptId5.Text)) { Store5.DataSource = routers.Items.Where(x => x.departmentId == DeptId5.Text); Store5.DataBind(); } if (!string.IsNullOrEmpty(DeptId6.Text)) { Store6.DataSource = routers.Items.Where(x => x.departmentId == DeptId6.Text); Store6.DataBind(); } }
public void FillWorkingCalendar() { ListRequest req = new ListRequest(); ListResponse <WorkingCalendar> response = _timeAttendanceService.ChildGetAll <WorkingCalendar>(req); if (!response.Success) { Common.errorMessage(response); Store3.DataSource = new List <Department>(); } Store3.DataSource = response.Items; Store3.DataBind(); }
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e) { int PageSize = this.pagecut.PageSize; int IndexSize = Convert.ToInt32(e.Parameters["start"]); if (IndexSize == -1) { IndexSize = 0; } int pageIndex = IndexSize / PageSize + 1; int recordCount = 0; List <Soft> list = biService.GetSofts((SoftTypeOptions)Convert.ToInt32(SelectSoftType.SelectedItem.Value), txtsoftName.Text, pageIndex, PageSize, ref recordCount); Store3.DataSource = list; Store3.DataBind(); (Store3.Proxy[0] as PageProxy).Total = recordCount; }
protected void RefreshData(object sender, StoreRefreshDataEventArgs e) { try { List <MathRule> tudien = new XMLProcess().GetAll(XDocument.Load(Server.MapPath(MathRuleXmlUrl)), true); List <object> obj = new List <object>(); foreach (var item in tudien) { obj.Add(new { ColumnInDB = item.ColumnInDB, ColumnInSoftware = item.ColumnInSoftware, ColumnInExcel = item.ColumnInExcel, AllowBlank = item.AllowBlank, MathStatus = item.MathStatus, DataType = item.DataType }); } Store3.DataSource = obj; Store3.DataBind(); } catch (Exception ex) { Dialog.ShowError(ex.Message.ToString()); } }
private void dataBind() { //项目数据 var projectList = XMProjectService.GetXMProjectList(); Store2.DataSource = projectList; Store2.DataBind(); //物流公司数据 var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(244); Store3.DataSource = logisticsList; Store3.DataBind(); //发货点数据(发货仓) var codeList = CodeService.GetCodeListInfoByCodeTypeID(188); Store4.DataSource = codeList; Store4.DataBind(); }
public void DisplayApprovals(string dayId, string employeeId, string shiftId, string code) { ReportGenericRequest req = new ReportGenericRequest(); req.paramString = "1|" + employeeId + "^2|" + dayId + "^3|" + dayId + "^5|" + code; ListResponse <Time> resp = _timeAttendanceService.ChildGetAll <Time>(req); if (!resp.Success) { Common.errorMessage(resp); return; } timeCode = ConstTimeVariationType.TimeCodeList(_systemService); resp.Items.ForEach(x => { x.timeCodeString = timeCode.Where(y => y.key == Convert.ToInt16(x.timeCode)).Count() != 0 ? timeCode.Where(y => y.key == Convert.ToInt32(x.timeCode)).First().value : string.Empty; x.statusString = FillApprovalStatus(x.status); }); Store3.DataSource = resp.Items; Store3.DataBind(); TimeApprovalWindow.Show(); }
protected void ReloadData(object sender, DirectEventArgs e) { //Store1.DataBind(); Store3.DataBind(); }
public void Save_GW(object sender, EventArgs e) { DataClasses1DataContext contador = new DataClasses1DataContext(); TGateways tGateway = new TGateways(); try { tGateway.SerialNumber = (int)txtSerialGW.Number; tGateway.Marca = txtMarcaGW.Text; tGateway.Modelo = txtModeloGW.Text; tGateway.IP = txtIPGW.Text; tGateway.Puerto = txtPuertoGW.Text; #region ADD ID VALUE var query = (from c in contador.TGateways select c); List <TGateways> listaValores = query.ToList <TGateways>(); var maxID = 0; if (listaValores.Count != 0) { maxID = listaValores.Max(x => x.Id); tGateway.Id = maxID++; tGateway.Id = maxID++; } else { maxID = 1; } #endregion #region check Serial var querydupli = (from c in contador.TGateways where c.SerialNumber == txtSerialGW.Number select c); List <TGateways> listaValoresdupli = querydupli.ToList <TGateways>(); #endregion if (listaValoresdupli.Count == 0) { var result = contador.GetTable <TGateways>(); // get table result.InsertOnSubmit(tGateway); contador.SubmitChanges(); // Response.Write("Saved Successfully..."); Store3.DataBind(); X.Msg.Notify("Line Saved Correctly At:", DateTime.Now.ToLongTimeString()).Show(); FormPanel3.Reset(); } else { X.Msg.Notify("Error Saving", "Serial Number Already exists!").Show(); } } catch (Exception ex) { throw new Exception(); } }
private void PreviewDataBind() { int year = common.IntSafeConvert(CurrentYear); DataTable dt1 = BG_PreviewDataLogic.GetPersonPart(); dt1.Columns.Add("rsold"); dt1.Columns.Add("rsnew"); dt1.Columns.Add("rjsold"); dt1.Columns.Add("rjsnew"); DataTable dt2 = BG_PreviewDataLogic.GetPublicPart(); dt2.Columns.Add("rsold"); dt2.Columns.Add("rsnew"); dt2.Columns.Add("rjsold"); dt2.Columns.Add("rjsnew"); DataTable dt3 = BG_PreviewDataLogic.GetCapitalPart(); dt3.Columns.Add("rsold"); dt3.Columns.Add("rsnew"); dt3.Columns.Add("rjsold"); dt3.Columns.Add("rjsnew"); for (int j = 0; j < dt1.Rows.Count; j++) { string pnumold = ""; string pnumnew = ""; DataTable dt = BG_SysSettingManager.GetAllBG_SysSetting(); if (dt.Rows.Count > 0) { pnumold = BG_SysSettingLogic.GetPerByYear(year - 1); pnumnew = BG_SysSettingLogic.GetPerByYear(year); hidbn1.Value = pnumnew; } else { pnumold = "0"; pnumnew = "0"; hidbn1.Value = pnumnew; } dt1.Rows[j]["rsold"] = pnumold; dt1.Rows[j]["rsnew"] = pnumnew; int Pepold = common.IntSafeConvert(pnumold); int Pepnew = common.IntSafeConvert(pnumnew); dt1.Rows[j]["rjsold"] = (Convert.ToDouble(dt1.Rows[j]["PDProjectLYData"]) / (Pepold * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.'); dt1.Rows[j]["rjsnew"] = (Convert.ToDouble(dt1.Rows[j]["PDProjectData"]) / (Pepnew * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.'); } for (int k = 0; k < dt2.Rows.Count; k++) { string pnumold = ""; string pnumnew = ""; DataTable dt = BG_SysSettingManager.GetAllBG_SysSetting(); if (dt.Rows.Count > 0) { pnumold = BG_SysSettingLogic.GetPerByYear(year - 1); pnumnew = BG_SysSettingLogic.GetPerByYear(year); hidbn2.Value = pnumnew; } else { pnumold = "0"; pnumnew = "0"; hidbn2.Value = pnumnew; } dt2.Rows[k]["rsold"] = pnumold; dt2.Rows[k]["rsnew"] = pnumnew; int Pepold = common.IntSafeConvert(pnumold); int Pepnew = common.IntSafeConvert(pnumnew); dt2.Rows[k]["rjsold"] = (Convert.ToDouble(dt2.Rows[k]["PDProjectLYData"]) / (Pepold * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.'); dt2.Rows[k]["rjsnew"] = (Convert.ToDouble(dt2.Rows[k]["PDProjectData"]) / (Pepnew * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.'); } for (int i = 0; i < dt3.Rows.Count; i++) { string pnumold = ""; string pnumnew = ""; DataTable dt = BG_SysSettingManager.GetAllBG_SysSetting(); if (dt.Rows.Count > 0) { pnumold = BG_SysSettingLogic.GetPerByYear(year - 1); pnumnew = BG_SysSettingLogic.GetPerByYear(year); hidbn3.Value = pnumnew; } else { pnumold = "0"; pnumnew = "0"; hidbn3.Value = pnumnew; } dt3.Rows[i]["rsold"] = pnumold; dt3.Rows[i]["rsnew"] = pnumnew; int Pepold = common.IntSafeConvert(pnumold); int Pepnew = common.IntSafeConvert(pnumnew); dt3.Rows[i]["rjsold"] = (Convert.ToDouble(dt3.Rows[i]["PDProjectLYData"]) / (Pepold * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.'); dt3.Rows[i]["rjsnew"] = (Convert.ToDouble(dt3.Rows[i]["PDProjectData"]) / (Pepnew * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.'); } Store2.DataSource = Getquota(dt1, hidbn1.Value == null ? "" : hidbn1.Value.ToString()); Store2.DataBind(); Store3.DataSource = Getquota(dt2, hidbn2.Value == null ? "" : hidbn2.Value.ToString()); Store3.DataBind(); Store1.DataSource = Getquota(dt3, hidbn3.Value == null ? "" : hidbn3.Value.ToString()); Store1.DataBind(); }
private void SearchLoad()//查询窗口初始化 { //初始化日期 df_begin.SelectedDate = System.DateTime.Today; df_end.SelectedDate = System.DateTime.Today; //df_begin.SelectedDate = System.DateTime.Today;//.AddDays(-1); //df_end.SelectedDate = System.DateTime.Today; #region 初始化职务 var pos = from p in dc.Position from per in dc.Person where p.Posid == per.Posid && per.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { p.Posid, p.Posname }; Store3.DataSource = pos; Store3.DataBind(); #endregion #region 初始化部门 //var dep = from d in dc.Department // where d.Fatherid == SessionBox.GetUserSession().DeptNumber // select new // { // d.Deptname, // Deptid = d.Deptnumber // }; //DeptStore.DataSource = dep; //DeptStore.DataBind(); var dep = from d in dc.Department from p in dc.Person where d.Deptnumber == p.Areadeptid && p.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { d.Deptname, Deptid = d.Deptnumber }; DeptStore.DataSource = dep; DeptStore.DataBind(); #endregion #region 初始化单位 if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1) { var dept = from d in dc.Department where d.Deptnumber.Substring(4) == "00000" && d.Deptname.EndsWith("矿") select new { d.Deptname, Deptid = d.Deptnumber }; UnitStore.DataSource = dept; UnitStore.DataBind(); cbbUnit.Disabled = false; cbb_position.Disabled = true; cbb_person.Disabled = true; cbb_part.Disabled = true; cbb_status.Disabled = true; } else { var dept = from d in dc.Department where d.Deptnumber == SessionBox.GetUserSession().DeptNumber select new { d.Deptname, Deptid = d.Deptnumber }; UnitStore.DataSource = dept; UnitStore.DataBind(); cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber; cbbUnit.Disabled = true; } #endregion //#region 初始化级别 //var lavel = from l in dc.Yinhuanlevel // select new // { // l.YHLevelID, // l.YHLevel // }; //LevelStore.DataSource = lavel; //LevelStore.DataBind(); //#endregion #region 初始化类型 int zyID = int.Parse(PublicMethod.ReadXmlReturnNode("ZY", this)); var type = from t in dc.CsBaseinfoset where t.Fid == zyID select new { YHTypeID = t.Infoid, YHType = t.Infoname }; TypeStore.DataSource = type; TypeStore.DataBind(); #endregion #region 初始化状态 StatusStore.DataBind(); #endregion }
private void PreviewDataBind() { DataTable dt = new DataTable(); dt.Columns.Add("PSName"); dt.Columns.Add("rjs1"); dt.Columns.Add("rjs2"); dt.Columns.Add("rjs3"); dt.Columns.Add("rjs4"); dt.Columns.Add("rjs5"); dt.Columns.Add("rjs6"); dt.Columns.Add("rjs7"); for (int i = 0; i < 5; i++) { dt.Rows.Add(); dt.Rows[i]["PSName"] = ""; dt.Rows[i]["rjs1"] = ""; dt.Rows[i]["rjs2"] = ""; dt.Rows[i]["rjs3"] = ""; dt.Rows[i]["rjs4"] = ""; dt.Rows[i]["rjs5"] = ""; dt.Rows[i]["rjs6"] = ""; dt.Rows[i]["rjs7"] = ""; } Store1.DataSource = dt; Store1.DataBind(); DataTable dt2 = new DataTable(); dt2.Columns.Add("PSName"); dt2.Columns.Add("rjs1"); dt2.Columns.Add("rjs2"); dt2.Columns.Add("rjs3"); dt2.Columns.Add("rjs4"); dt2.Columns.Add("rjs5"); dt2.Columns.Add("rjs6"); dt2.Columns.Add("rjs7"); dt2.Columns.Add("rjs8"); dt2.Columns.Add("rjs9"); for (int i = 0; i < 5; i++) { dt2.Rows.Add(); dt2.Rows[i]["PSName"] = ""; dt2.Rows[i]["rjs1"] = ""; dt2.Rows[i]["rjs2"] = ""; dt2.Rows[i]["rjs3"] = ""; dt2.Rows[i]["rjs4"] = ""; dt2.Rows[i]["rjs5"] = ""; dt2.Rows[i]["rjs6"] = ""; dt2.Rows[i]["rjs7"] = ""; dt2.Rows[i]["rjs8"] = ""; dt2.Rows[i]["rjs9"] = ""; } Store2.DataSource = dt2; Store2.DataBind(); DataTable dt3 = new DataTable(); dt3.Columns.Add("PSName"); dt3.Columns.Add("rjs1"); dt3.Columns.Add("rjs2"); dt3.Columns.Add("rjs3"); dt3.Columns.Add("rjs4"); dt3.Columns.Add("rjs5"); dt3.Columns.Add("rjs6"); dt3.Columns.Add("rjs7"); dt3.Columns.Add("rjs8"); dt3.Columns.Add("rjs9"); dt3.Columns.Add("rjs10"); dt3.Columns.Add("rjs11"); dt3.Columns.Add("rjs12"); dt3.Columns.Add("rjs13"); dt3.Columns.Add("rjs14"); for (int i = 0; i < 5; i++) { dt3.Rows.Add(); dt3.Rows[i]["PSName"] = ""; dt3.Rows[i]["rjs1"] = ""; dt3.Rows[i]["rjs2"] = ""; dt3.Rows[i]["rjs3"] = ""; dt3.Rows[i]["rjs4"] = ""; dt3.Rows[i]["rjs5"] = ""; dt3.Rows[i]["rjs6"] = ""; dt3.Rows[i]["rjs7"] = ""; dt3.Rows[i]["rjs8"] = ""; dt3.Rows[i]["rjs9"] = ""; dt3.Rows[i]["rjs10"] = ""; dt3.Rows[i]["rjs11"] = ""; dt3.Rows[i]["rjs12"] = ""; dt3.Rows[i]["rjs13"] = ""; dt3.Rows[i]["rjs14"] = ""; } Store3.DataSource = dt3; Store3.DataBind(); DataTable dt4 = BG_PayProjectManager.GetAllBG_PayProject(); dt4.Columns.Add("rjs1"); dt4.Columns.Add("rjs2"); dt4.Columns.Add("rjs3"); dt4.Columns.Add("rjs4"); dt4.Columns.Add("rjs5"); dt4.Columns.Add("rjs6"); dt4.Columns.Add("rjs7"); dt4.Columns.Add("rjs8"); dt4.Columns.Add("rjs9"); dt4.Columns.Add("rjs10"); dt4.Columns.Add("rjs11"); dt4.Columns.Add("rjs12"); dt4.Columns.Add("rjs13"); for (int i = 0; i < 5; i++) { dt4.Rows[i]["rjs1"] = "0"; dt4.Rows[i]["rjs2"] = "0"; dt4.Rows[i]["rjs3"] = "0"; dt4.Rows[i]["rjs4"] = "0"; dt4.Rows[i]["rjs5"] = "0"; dt4.Rows[i]["rjs6"] = "0"; dt4.Rows[i]["rjs7"] = "0"; dt4.Rows[i]["rjs8"] = "0"; dt4.Rows[i]["rjs9"] = "0"; dt4.Rows[i]["rjs10"] = "0"; dt4.Rows[i]["rjs11"] = "0"; dt4.Rows[i]["rjs12"] = "0"; dt4.Rows[i]["rjs13"] = "0"; } Store4.DataSource = dt4; Store4.DataBind(); }