private void BindDataGrid() { sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn); //dtQuoteAndOrder = eCommerceReport.GetQuote2OrderData(periodMonth, periodYear,customerNo); //dtQuote2Order = eCommerceReport.CreateJoins(dtQuoteAndOrder, GetCustomers()); //dtQuote2Order.DefaultView.Sort = hidSort.Value; DataTable dtCCR = CCR.GetContactReport(strBranch, strCustType, strContactType, strBG, strFilterDt); if (dtCCR.Rows.Count > 0) { dtCCR.DefaultView.Sort = hidSort.Value; dgReport.DataSource = dtCCR.DefaultView.ToTable(); //dgReport.DataBind(); Pager1.Visible = true; Pager1.InitPager(dgReport, pagesize); lblStatus.Visible = false; } else { Pager1.Visible = false; lblStatus.Visible = true; lblStatus.Text = "No Records Found"; } }
private void BindDataGrid() { try { if (dtTotal.Rows.Count > 0) { GetTotal(); dgDayReport.DataSource = dsReport.Tables[0]; dgDayReport.Visible = true; lblStatus.Visible = false; Pager1.InitPager(dgDayReport, pagesize); Pager1.Visible = true; udpReportContent.Update(); } else { dgDayReport.Visible = false; Pager1.Visible = false; lblStatus.Visible = true; lblStatus.Text = "No Records Found"; } } catch (Exception ex) { throw ex; } //lblStatus.Text = "No Records Found"; //lblStatus.Visible = (dgDayReport.Items.Count < 1) ? true : false; }
protected void BindDatagrid(string where) { lblMsg.Visible = false; dgRequestQuote.Visible = true; Pager1.Visible = true; DataTable dtRequestQuote = requestQuote.GetRequestQuote(where); if (dtRequestQuote.Rows.Count > 0) { dtRequestQuote.DefaultView.Sort = (hidSort.Value == "") ? "SessionID desc" : hidSort.Value; dgRequestQuote.DataSource = dtRequestQuote.DefaultView.ToTable(); if (dtRequestQuote.Rows.Count >= 15) { Pager1.InitPager(dgRequestQuote, 15); } else { Pager1.InitPager(dgRequestQuote, dtRequestQuote.Rows.Count); Pager1.Visible = false; } } else { lblMsg.Visible = true; dgRequestQuote.Visible = false; Pager1.Visible = false; } upnlQuote.Update(); }
private void BindDataGrid() { if (PageMode != "pircemode") { string dbSourcetype = (PageMode != "itemhistory" ? "getgriditems" : "getitemhistory"); DataTable dtCompItems = GetCompetitorTablesData(dbSourcetype, hidRegionId.Value, ddlCompName.SelectedItem.Value, PFCItemNo, ""); if (dtCompItems != null) { if (PageMode == "itemhistory") { dgCompPrice.Columns[0].Visible = false; } dtCompItems.DefaultView.Sort = (hidSort.Value == "") ? "" : hidSort.Value; dgCompPrice.DataSource = dtCompItems.DefaultView.ToTable(); Pager1.InitPager(dgCompPrice, 50); Pager1.Visible = true; //dgCompPrice.DataBind(); upnlGrid.Update(); if (dtCompItems.Rows.Count == 0) { DisplaStatusMessage("No Records Found", "Fail"); } } else { DisplaStatusMessage("No Records Found", "Fail"); } } }
protected void BindDataGrid() { if (txtSearchCustNo.Text.ToString() == (txtOrganizationNo.Text.ToString())) // keeps both grids if customer is requested again { dsItemAlias = SqlHelper.ExecuteDataset(cnxERP, CommandType.StoredProcedure, "[pMaintItemAlias]" , new SqlParameter("@ItemNo", txtSearchItemNo.Text) , new SqlParameter("@OrganizationNo", txtSearchCustNo.Text)); //See stored procedure to for code to allow null by case of LIKE statement dgItemAliasGrid.DataSource = dsItemAlias.Tables[0].DefaultView.ToTable(); } else { dsItemAlias = SqlHelper.ExecuteDataset(cnxERP, CommandType.StoredProcedure, "[pMaintItemAlias]" , new SqlParameter("@ItemNo", txtSearchItemNo.Text) , new SqlParameter("@OrganizationNo", txtSearchCustNo.Text)); //See stored procedure to for code to allow null by case of LIKE statement dgItemAliasGrid.DataSource = dsItemAlias.Tables[0].DefaultView.ToTable(); ClearControls(); } Pager1.InitPager(dgItemAliasGrid, 14); divAliasGrid.Visible = true; //make div visible since it is set as false in page (grid) pnlAliasGrid.Update(); //Refresh panels when clicking, all the time ! }
protected void Page_Load(object sender, EventArgs e) { Ajax.Utility.RegisterTypeForAjax(typeof(WOFind)); if (!IsPostBack) { GetSecurity(); dgFind.PageSize = PageSize; ViewState["MaxRowCount"] = BusinessLogic.GetSQLWarningRowCount(); //ViewState["MaxRowCount"] = "9999"; BindFindControls(); ClearFindControls(); dtStartDt.SelectedDate = DateTime.Now.AddDays(-7).ToShortDateString(); dtEndDt.SelectedDate = DateTime.Now.ToShortDateString(); dtEmpty.Clear(); dgFind.DataSource = dtEmpty.DefaultView.ToTable(); dgFind.DataBind(); Pager1.InitPager(dgFind, PageSize); } }
private void BindDataGrid() { dtUnrcvdPO = (DataTable)Session["dtPO"]; TotLines = dtUnrcvdPO.DefaultView.ToTable().Rows.Count; lblTotLines.Text = "Total number of lines: " + String.Format("{0:n0}", TotLines); TotQtyOrd = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(QtyOrdered)", "")); lblTotQtyOrd.Text = String.Format("{0:n0}", TotQtyOrd); TotQtyRcvd = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(QtyReceived)", "")); lblTotQtyRcvd.Text = String.Format("{0:n0}", TotQtyRcvd); TotQtyDue = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(QtyDue)", "")); lblTotQtyDue.Text = String.Format("{0:n0}", TotQtyDue); TotExtCost = Convert.ToDecimal(dtUnrcvdPO.Compute("sum(ExtendedCost)", "")); lblTotExtCost.Text = String.Format("{0:c}", TotExtCost); tblGrdTotals.Visible = true; dtUnrcvdPOCat = SelectDistinct(dtUnrcvdPO.DefaultView.ToTable(), "CatNo"); //if (!string.IsNullOrEmpty(txtCat.Text.ToString())) // dtUnrcvdPOCat.DefaultView.RowFilter = "CatNo = '" + txtCat.Text.ToString() + "'"; dtUnrcvdPOCat.DefaultView.Sort = "CatNo ASC"; dgUnrcvdPOCat.DataSource = dtUnrcvdPOCat.DefaultView.ToTable(); dgUnrcvdPOCat.AllowPaging = true; dgUnrcvdPOCat.DataBind(); pnlRptGrid.Update(); Pager1.InitPager(dgUnrcvdPOCat, 1); Pager1.Visible = true; pnlPager.Update(); }
private void BindDataGrid() { sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn); dsQuoteAnalysis = eCommerceReport.GetDtlData(periodMonth, periodYear, startDate, endDate, branchNo, customerNo, orderSource, sourceType, itemNotOrd, quoteNumber); dtQuoteAnalysis = eCommerceReport.AverageCostJoins(dsQuoteAnalysis.Tables[0], eCommerceReport.GetAverageCost(dsQuoteAnalysis.Tables[0])); DataColumn dcAverageCost = new DataColumn("MarginPercentage", System.Type.GetType("System.Double")); dcAverageCost.Expression = "IIF([UnitPrice]=0, 0,(((UnitPrice - AvgCost) / UnitPrice) * 100))"; dtQuoteAnalysis.Columns.Add(dcAverageCost); dtQuoteAnalysis.DefaultView.Sort = sortExpression; if (dtQuoteAnalysis.Rows.Count > 0) { dgQuoteAnalysis.DataSource = dtQuoteAnalysis.DefaultView.ToTable(); Pager1.Visible = true; Pager1.InitPager(dgQuoteAnalysis, pagesize); lblStatus.Visible = false; } else { Pager1.Visible = false; lblStatus.Visible = true; lblStatus.Text = "No Records Found"; } }
protected void BindGrid() { string GridColumns = "Hdr.BOLNo, max(BOLDate) as BolDate, sum(Det.UOMatlAmt) as BOLMatl"; GridColumns += ", sum(UODutyAmt + UOOceanFrghtAmt + UOBrokerageAmt + UODrayAmt + UOMerchProcFee + UOHarborMaintFee + isnull(UOMiscWghtFee,0) + UOTrkFrghtAmt) as BOLLanded"; GridColumns += ", 0.0 as APMatl, 0.0 as APLanded, 0.0 as GERvsAP, 0.0 as APVariance, 0.0 as GERTot, 0.0 as APTot, 0.0 as TotalVariance"; ds = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["ReportsConnectionString"].ToString(), "[UGEN_SP_Select]", new SqlParameter("@tableName", "GERHeaderHist Hdr inner join GERDetailHist Det on Hdr.BOLNo=Det.BOLNo"), new SqlParameter("@displayColumns", GridColumns), new SqlParameter("@whereCondition", "Hdr.BOLNo='" + BOL + "' group by Hdr.BOLNo order by Hdr.BOLNo")); dt = ds.Tables[0]; if (dt.Rows.Count == 0) { lblErrorMessage.Text = "Nothing on file for BOL " + BOL; } else { //lblSuccessMessage.Text = "BOL " + BOL + " processed"; foreach (DataRow row in dt.Rows) { row["GERTot"] = (decimal)row["BOLMatl"] + (decimal)row["BOLLanded"]; GetNVData(row); row["APTot"] = (decimal)row["APMatl"] + (decimal)row["APLanded"] + (decimal)row["APVariance"]; row["GERvsAP"] = (decimal)row["GERTot"] - ((decimal)row["APMatl"] + (decimal)row["APLanded"]); row["TotalVariance"] = (decimal)row["GERTot"] - (decimal)row["APTot"]; } } ReconGrid.DataSource = dt.DefaultView.ToTable(); Pager1.InitPager(ReconGrid, pagesize); }
private void BindDataGrid() { sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn); //dtQuoteAndOrder = eCommerceReport.GetQuote2OrderData(periodMonth, periodYear,customerNo); //dtQuote2Order = eCommerceReport.CreateJoins(dtQuoteAndOrder, GetCustomers()); //dtQuote2Order.DefaultView.Sort = hidSort.Value; dtQuote2Order = eCommerceReport.GetQuote2OrderData(periodMonth, periodYear, startDate, endDate, locationCode, customerNo, repNo, priceCdCtl); if (dtQuote2Order != null && dtQuote2Order.Rows.Count > 0) { dtQuote2Order.DefaultView.Sort = hidSort.Value; dgQuote2Order.DataSource = dtQuote2Order.DefaultView.ToTable(); Pager1.Visible = true; Pager1.InitPager(dgQuote2Order, pagesize); lblStatus.Visible = false; } else { Pager1.Visible = false; lblStatus.Visible = true; lblStatus.Text = "No Records Found"; } }
public void BindDataGrid() { stDate = Convert.ToDateTime(ddlStMonth.SelectedValue.ToString() + "/01/" + ddlStYear.SelectedValue.ToString()); endDate = Convert.ToDateTime(ddlEndMonth.SelectedValue.ToString() + "/28/" + ddlEndYear.SelectedValue.ToString()); PrintDialogue1.CustomerNo = custNumber; PrintDialogue1.PageTitle = "Sales history for " + custNumber; string TempUrl = "saleshistoryExport.aspx?CustomerNumber=" + custNumber + "&SONumber=" + hidSoNumber.Value.ToString() + "&frmMonth=" + ddlStMonth.SelectedValue.ToString() + "&frmYear=" + ddlStYear.SelectedValue.ToString() + "&endMonth=" + ddlEndMonth.SelectedValue.ToString() + "&endYear=" + ddlEndYear.SelectedValue.ToString(); PrintDialogue1.PageUrl = Server.UrlEncode(TempUrl); dsSalesHistory = salesHis.GetSalesHistory(custNumber, stDate, endDate); if (dsSalesHistory.Rows.Count > 0 && dsSalesHistory != null) { lblMsg.Visible = false; } else { lblMsg.Text = "No Records found"; lblMsg.Visible = true; } dsSalesHistory.DefaultView.Sort = (hidSort.Value == "") ? "itemNo asc" : hidSort.Value; dgSalesHistory.DataSource = dsSalesHistory; Pager1.InitPager(dgSalesHistory, pagesize); upSalesHistoryGrid.Update(); }
public void BindDataGrid(DataTable dtCerts) { Session["CertsInformation"] = dtCerts; gvCertificates.DataSource = dtCerts; gvCertificates.DataBind(); Pager1.InitPager(gvCertificates, pageSize); }
public void BindDataGrid() { adp = new SqlDataAdapter(cmdRGASummary, cnxNV); adp.Fill(ds, "RGASummary"); GridView1.DataSource = ds.Tables["RGASummary"]; GridView1.DataBind(); Pager1.InitPager(GridView1, 20); }
public void BindDataGrid() { String sortExpression = (hidSort.Value == "") ? " MarginPerLb DESC" : hidSort.Value; adp = new SqlDataAdapter(cmd); ds.Clear(); adp.Fill(ds, "Profit"); ds.Tables["Profit"].DefaultView.Sort = sortExpression; GridView1.DataSource = ds.Tables["Profit"].DefaultView.ToTable(); if (ds.Tables["Profit"].Rows.Count > 0) { GrdTotMgnDollars = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(MarginDollars)", "")); lblTotMgnDollars.Text = String.Format("{0:c}", GrdTotMgnDollars); GrdTotProfit = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(Profit)", "")); lblTotProfit.Text = String.Format("{0:c}", GrdTotProfit); GrdTotPounds = Math.Round(Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(Lbs)", "")), 2); lblTotPounds.Text = String.Format("{0:0,0.00}", GrdTotPounds); GrdTotSales = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(SalesDollars)", "")); lblTotSales.Text = String.Format("{0:c}", GrdTotSales); if (GrdTotPounds == 0) { lblTotMgnPerLb.Text = "0"; } else { lblTotMgnPerLb.Text = String.Format("{0:c}", GrdTotMgnDollars / GrdTotPounds); } if (GrdTotSales == 0) { lblTotMgnPct.Text = "0"; } else { lblTotMgnPct.Text = String.Format("{0:N2}%", GrdTotMgnDollars / GrdTotSales * 100); } GrdTotSales = Convert.ToDecimal(ds.Tables["Profit"].Compute("sum(SalesDollars)", "")); lblTotSales.Text = String.Format("{0:c}", GrdTotSales); if (GrdTotPounds == 0) { lblTotPricePerLb.Text = "0"; } else { lblTotPricePerLb.Text = String.Format("{0:c}", GrdTotSales / GrdTotPounds); } } Pager1.InitPager(GridView1, 22); }
protected void ibtnCancel_Click(object sender, ImageClickEventArgs e) { lblMessage.Text = ""; pnlStatus.Update(); ClearFindControls(); dgFind.DataSource = dtEmpty.DefaultView.ToTable(); dgFind.DataBind(); Pager1.InitPager(dgFind, PageSize); pnlWOGrid.Update(); }
public void BindDataToGrid() { try { ExcelExport(); BindDataGridHeader(); System.Data.DataTable dt = (System.Data.DataTable)Session["BranchItem"]; dt.DefaultView.Sort = hidSort.Value; Session["BranchItem"] = dt.DefaultView.ToTable(); dgAnalysis.DataSource = dt.DefaultView.ToTable(); if (dt.Rows.Count > 0) { Pager1.InitPager(dgAnalysis, pagesize); DropDownList ddl = Pager1.FindControl("ddlPages") as DropDownList; if (ddl.SelectedItem.Value.ToString() == ddl.Items.Count.ToString()) { dgAnalysis.ShowFooter = true; } else { dgAnalysis.ShowFooter = false; } if (dgAnalysis.Items.Count <= 0) { dgAnalysis.Visible = false; btnPrint.Visible = false; tblPager.Visible = false; lblStatus.Visible = true; } else { dgAnalysis.Visible = true; btnPrint.Visible = true; tblPager.Visible = true; lblStatus.Visible = false; } } else { dgAnalysis.Visible = false; btnPrint.Visible = false; tblPager.Visible = false; lblStatus.Visible = true; } } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
public void BindDataGrid() { string sortExpression = (hidSort.Value == "") ? " [PO No] Asc" : hidSort.Value; adp = new SqlDataAdapter(cmd); ds.Clear(); adp.Fill(ds, "POVendorConf"); ds.Tables["POVendorConf"].DefaultView.Sort = sortExpression; GridView1.DataSource = ds.Tables["POVendorConf"].DefaultView.ToTable(); GridView1.DataBind(); Pager1.InitPager(GridView1, 20); }
public void BindDataGrid() { string sortExpression = (hidSort.Value == "") ? " [ItemNo], [Loc] Asc" : hidSort.Value; adp = new SqlDataAdapter(cmd); ds.Clear(); adp.Fill(ds, "AItems"); ds.Tables["AItems"].DefaultView.Sort = sortExpression; GridView1.DataSource = ds.Tables["AItems"].DefaultView.ToTable(); GridView1.DataBind(); Pager1.InitPager(GridView1, 18); }
private void BindDataGrid() { Pager1.Visible = true; //string searchText = GetSearchText(); lblDeleteDate.Text = ""; string searchText = "DeleteDt is null"; Clear(); dtTablesData = glaccount.GetDataGridPostingRecords(searchText); if (dtTablesData != null) { dtTablesData.DefaultView.Sort = (hidSort.Value == "") ? "pGLAcctMasterID desc" : hidSort.Value; dgCountryCode.DataSource = dtTablesData.DefaultView.ToTable(); //dgCountryCode.DataBind(); Pager1.InitPager(dgCountryCode, 25); if (dtTablesData.Rows.Count == 1) { if (Page.IsPostBack) { // // Fetch Data From Table // hidPrimaryKey.Value = dtTablesData.Rows[0]["pGLAcctMasterID"].ToString().Trim(); dtTablesData = glPosting.GetPostingRecords("pGLAcctMasterID = '" + hidPrimaryKey.Value + "'"); DisplayRecord(); btnSave.Visible = (CountrySecurity != "") ? true : false; //btnDelete.Visible = (CountrySecurity != "") ? true : false; if (ViewState["Operation"].ToString() == "Save" || ViewState["Operation"].ToString() == "Delete" || ViewState["Operation"].ToString() == "Clear") { Clear(); } } else { btnSave.Visible = false; btnDelete.Visible = false; } } if (dtTablesData.Rows.Count == 0) { DisplaStatusMessage("No Records Found", "Fail"); } } else { DisplaStatusMessage("No Records Found", "Fail"); } SelectItem(ddlLocation, Session["BranchID"].ToString()); UpdatePanels(); }
private void BindDataGrid() { dtWorkSheet = (DataTable)Session["dtWS"]; dtWorkSheet.DefaultView.Sort = (hidSort.Value == "") ? "ActionStatus ASC, WOItemNo ASC, PriorityCd ASC" : hidSort.Value; dgWorkSheet.DataSource = dtWorkSheet.DefaultView.ToTable(); dgWorkSheet.AllowPaging = true; dgWorkSheet.DataBind(); pnlWSGrid.Update(); hidRowCount.Value = dtWorkSheet.Rows.Count.ToString(); Session["dtWS"] = dtWorkSheet.DefaultView.ToTable(); Pager1.InitPager(dgWorkSheet, PageSize); Pager1.Visible = true; pnlPager.Update(); }
private void BindDataGrid() { dsExcessInv = (DataSet)Session["dsExInv"]; dtExcessInv = dsExcessInv.Tables[0]; dtExcessInv.DefaultView.Sort = (hidSort.Value == "") ? "ItemNo ASC, Branch ASC" : hidSort.Value; dgExcessInv.DataSource = dtExcessInv.DefaultView.ToTable(); dgExcessInv.AllowPaging = true; dgExcessInv.DataBind(); pnlRptGrid.Update(); hidRowCount.Value = dsExcessInv.Tables[0].Rows.Count.ToString(); Pager1.InitPager(dgExcessInv, PageSize); Pager1.Visible = true; pnlPager.Update(); }
public void BindDataToGrid() { try { dsVendorForeCast = vendorforeCast.GetVendorForeCastData(Session["VendorMultiplier"].ToString(), Session["VendorCategory"].ToString(), Session["VendorVariance"].ToString(), Session["VendorPlatingType"].ToString(), Session["VendorSort"].ToString()); dtVendorForeCast = dsVendorForeCast.Tables[0]; dtVFCSort = dsVendorForeCast.Tables[1]; //ExcelExport(); if (dtVFCSort.Rows.Count == 0) { lblStatus.Visible = true; Pager1.Visible = false; } // Grand Total foreCastUSG = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(ForeCastUSG)", ""))); usgUOM = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(USGUOM)", ""))); usgLBS = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(USGLBS)", ""))); usgKGS = String.Format("{0:#,##0}", Convert.ToDecimal(dtVFCSort.Compute("Sum(USGKGS)", ""))); footerContent = ""; footerContent += "<table border='0' width='100%' cellpadding='0'cellspacing='0'>"; footerContent += "<tr><td style='width:511px' class='GridHead' align='right'>Grand Total</td>"; footerContent += "<td style='width:73px' class='GridHead' align='right'>" + foreCastUSG + "</td>"; footerContent += "<td style='width:74px' class='GridHead' align='right'>" + usgUOM + "</td>"; footerContent += "<td style='width:78px' class='GridHead' align='right'>" + usgLBS + "</td>"; footerContent += "<td class='GridHead' align='right'>" + usgKGS + "</td></tr></table>"; dgCategory.Columns[0].FooterText = footerContent; dgCategory.DataSource = dtVFCSort; Pager1.InitPager(dgCategory, 1); if (dgCategory.CurrentPageIndex != Pager1.GetTotalNoOfPages - 1) { dgCategory.ShowFooter = false; } else { dgCategory.ShowFooter = true; } dgCategory.DataBind(); GetTotalPages(); } catch (Exception ex) { //Response.Write(ex.Message.ToString()); } }
private void BindDataGrid() { DataSet dsVendItems = new DataSet(); string pfcItemNo = txtSearchItemNo.Text; if (txtCategory.Text.Trim() != "" || txtSize.Text.Trim() != "" || txtVar.Text.Trim() != "") { pfcItemNo = "Category-Size-Var"; pfcItemNo = (txtCategory.Text.Trim() != "" ? pfcItemNo.Replace("Category", txtCategory.Text) : pfcItemNo.Replace("Category", "%%%%%")); pfcItemNo = (txtSize.Text.Trim() != "" ? pfcItemNo.Replace("Size", txtSize.Text) : pfcItemNo.Replace("Size", "%%%%")); pfcItemNo = (txtVar.Text.Trim() != "" ? pfcItemNo.Replace("Var", txtVar.Text) : pfcItemNo.Replace("Var", "%%%")); } if (txtSearchItemNo.Text.Trim() != "") { pfcItemNo = txtSearchItemNo.Text; } dsVendItems = GetPriceCostTablesData(ViewState["GridViewMode"].ToString(), pfcItemNo, ddlSearchLocation.SelectedValue, "", "", ""); if (dsVendItems != null && dsVendItems.Tables.Count > 1) { dsVendItems.Tables[0].DefaultView.Sort = (hidSort.Value == "") ? "" : hidSort.Value; Session["PriceCostExcelData"] = dsVendItems.Tables[0].DefaultView.ToTable(); dgPriceCost.DataSource = dsVendItems.Tables[0].DefaultView.ToTable(); Pager1.InitPager(dgPriceCost, 13); Pager1.Visible = true; if (dsVendItems.Tables[0].Rows.Count == 0) { DisplaStatusMessage("No Records Found", "Fail"); } } else { DisplaStatusMessage("No Records Found", "Fail"); dgPriceCost.DataSource = null; dgPriceCost.DataBind(); } upnlGrid.Update(); //ScriptManager.RegisterClientScriptBlock(dgVendorPrice, dgVendorPrice.GetType(), "setMenu", "RestoreControlPosition();", true); }
public void BindDataGrid() { cmd = new SqlCommand("pACGetItemBranchDetail", cnxAC); cmd.Parameters.AddWithValue("@BeginDt", Request.QueryString["BeginDt"].ToString()); cmd.Parameters.AddWithValue("@EndDt", Request.QueryString["EndDt"].ToString()); cmd.Parameters.AddWithValue("@ItemNo", Request.QueryString["ItemNo"].ToString()); cmd.Parameters.AddWithValue("@Branch", Request.QueryString["Branch"].ToString()); cmd.CommandType = CommandType.StoredProcedure; adp = new SqlDataAdapter(cmd); dsAC.Clear(); adp.Fill(dsAC, "AC"); String sortExpression = (hidSort.Value == "") ? " CurDate ASC" : hidSort.Value; dsAC.Tables["AC"].DefaultView.Sort = sortExpression; GridView1.DataSource = dsAC.Tables["AC"].DefaultView.ToTable(); Pager1.InitPager(GridView1, 22); }
public void BindDataToGrid() { try { ExcelExport(); utility.CheckBrowserCompatibility(Request, dgReport); dgReport.DataSource = dtReport; Pager1.InitPager(dgReport, 2); tdGrid.Visible = (dgReport.Items.Count < 1) ? false : true; lblMsg.Visible = (dgReport.Items.Count < 1) ? true : false; tdPager.Visible = (dgReport.Items.Count < 1) ? false : true; foreach (DataGridItem dgItem in dgReport.Items) { Label lblCategory = dgItem.FindControl("lblCategory") as Label; Label lblVariance = dgItem.FindControl("lblVariance") as Label; Label lblPlating = dgItem.FindControl("lblPlating") as Label; Label lblPlatingDescription = dgItem.FindControl("lblPlatingDescription") as Label; Label lblFiscalMonth = dgItem.FindControl("FiscalMonth") as Label; Label lblFiscalYear = dgItem.FindControl("FiscalYear") as Label; Label lblMessage = dgItem.FindControl("lblMessage") as Label; DataGrid dgData = dgItem.FindControl("dgAnalysis") as DataGrid; utility.CheckBrowserCompatibility(Request, dgData); // to pass parameter in get url function strCategory = lblCategory.Text; try { dt.DefaultView.RowFilter = "Category=" + lblCategory.Text + " and Plating='" + lblPlating.Text + "' and PlatingDescription='" + lblPlatingDescription.Text + "' and Variance='" + lblVariance.Text + "'"; string sortExpression = ((hidSort.Value != "") ? " " + hidSort.Value : ""); dt.DefaultView.Sort = sortExpression; dgData.DataSource = dt.DefaultView; dgData.DataBind(); dgData.Columns[6].Visible = (rdoReportVersion1.Checked == true) ? true : false; dgData.Columns[9].Visible = (rdoReportVersion1.Checked == true) ? true : false; dgData.Width = (rdoReportVersion1.Checked) ? 815 : 650; } catch (Exception ex) { } lblMessage.Visible = (dgData.Items.Count >= 1) ? false : true; } } catch (Exception ex) { } }
private void BindDataToDataGrid() { try { whereCondition = "ContractNo='" + strContractNo + "' and Chain='" + Request.QueryString["ChainName"].Replace("||", "&").ToString() + "'"; dsReport = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["ReportsConnectionString"].ToString(), "[ugen_sp_select]", new SqlParameter("@tableName", "VMI_Contract"), new SqlParameter("@displayColumns", "ContractNo,Chain,ItemNo,ItemDesc,SubItemNo,CrossRef,round(E_Profit_Pct*100,1) as E_Profit_Pct,convert(varchar,cast((cast(isnull(ContractPrice,0) as decimal(25,2))) as money),1) as ContractPrice,replace(convert(varchar,cast((cast(isnull(EAU_Qty,0) as bigint)) as money),1),'.00','') as EAU_Qty,convert(char(11),cast(StartDate as DateTime),101) as StartDate,convert(char(11),cast(EndDate as DateTime),101) as EndDate,Salesperson,OrderMethod,Vendor,Contact,ContactPhone, cast(isnull(MonthFactor,0) as decimal(25,1)) as MonthFactor,Closed,CustomerPO"), new SqlParameter("@whereCondition", whereCondition)); dtReport = dsReport.Tables[0]; dgReport.DataSource = dtReport; //dgReport.DataBind(); Pager1.InitPager(dgReport, pagesize); } catch (Exception ex) { Response.Write(ex.Message); } }
private void BindDataGrid() { String sortExpression = (hidSort.Value == "") ? " Category ASC, ItemCVC ASC" : hidSort.Value; strSQL = "SELECT *, DiscountPercent / 100 AS GridDiscPct FROM WebCategoryDiscount (NoLock)"; //strSQL = "SELECT *, DiscountPercent / 100 AS GridDiscPct FROM WebCategoryDiscount (NoLock)"; if (chkDelRec.Checked == false) { strSQL = strSQL + " WHERE DeleteDt = '' OR DeleteDt is null"; } strSQL = strSQL + " ORDER BY " + sortExpression; dsWebCatDisc = SqlHelper.ExecuteDataset(cnWebCatDisc, CommandType.Text, strSQL); dsWebCatDisc.Tables[0].DefaultView.Sort = sortExpression; dgWebCatDisc.DataSource = dsWebCatDisc.Tables[0].DefaultView.ToTable(); dgWebCatDisc.DataBind(); cnWebCatDisc.Close(); Pager1.InitPager(dgWebCatDisc, Convert.ToInt16(hidPageSize.Value)); pnlCatGrid.Update(); }
private void BindDataGrid() { sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn); dsPurchFactor = MnthlyPrchasingBdgtData.GetAllFactors(); dtTotal = dsPurchFactor.Tables[0]; dtTotal.DefaultView.Sort = sortExpression; dtTotal = dsPurchFactor.Tables[0].DefaultView.ToTable(); if (dtTotal.Rows.Count > 0) { dgPurchFactor.DataSource = dtTotal; dgPurchFactor.DataBind(); Pager1.InitPager(dgPurchFactor, pagesize); Pager1.Visible = true; } else { Pager1.Visible = false; } lblStatus.Text = "No Records Found"; lblStatus.Visible = (dgPurchFactor.Items.Count < 1) ? true : false; }
private void BindDataGrid() { sortExpression = ((hidSort.Value != "") ? hidSort.Value : keyColumn); dtECommSales = eCommerceReportV2.GetQuoteAndOrderData(periodMonth, periodYear, startDate, endDate, locationCode, customerNo, repNo, priceCdCtl, orderSource, itemNotOrd); if (dtECommSales != null && dtECommSales.Rows.Count > 0) { dtECommSales.DefaultView.Sort = hidSort.Value; dgECommSales.DataSource = dtECommSales.DefaultView.ToTable(); Pager1.Visible = true; Pager1.InitPager(dgECommSales, pagesize); lblStatus.Visible = false; } else { Pager1.Visible = false; lblStatus.Visible = true; lblStatus.Text = "No Records Found"; } }
private void BindDataGrid() { sortExpression = ((hidSort.Value != "") ? " ORDER BY " + hidSort.Value : " ORDER BY " + keyColumn); dsDayReport = DayInventoryReport.GetDayReport(strStatus, sortExpression); dtTotal = dsDayReport.Tables[0].DefaultView.ToTable(); if (dtTotal.Rows.Count > 0) { GetTotal(); dgDayReport.DataSource = dsDayReport.Tables[0]; dgDayReport.DataBind(); Pager1.InitPager(dgDayReport, pagesize); Pager1.Visible = true; } else { Pager1.Visible = false; } lblStatus.Text = "No Records Found"; lblStatus.Visible = (dgDayReport.Items.Count < 1) ? true : false; }