protected void BindData() { //Step First //DataSet ds = objtec.GetAuditTrailSummary("BEX-10-00004", "313", "313100510095907", ""); DataSet dsAuditSumry = objtec.GetAuditTrailSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["QUOTATION_CODE"].ToString()); DataTable dtVesselDtl = objtec.Get_VID_VesselDetails(UDFLib.ConvertToInteger(Request.QueryString["Vessel_Code"].ToString())); if (dtVesselDtl.Rows.Count > 0) { //lblVessel.Text = Convert.ToString(dtVesselDtl.Rows[0]["VesselName"]); //lblVesselExName1.Text = Convert.ToString(dtVesselDtl.Rows[0]["VesselExNames"]); //lblVesselHullNo.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Hull_No"]); //lblVesselType.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Type"]); //lblVesselYard.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Yard"]); //lblVesselDelvDate.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Delvry_Date"]); //lblIMOno.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_IMO_No"]); } BLL_PURC_Purchase objhold = new BLL_PURC_Purchase(); rgdHoldLog.DataSource = objhold.GetRequisitionOnHoldLogHistory_ByReqsn(Request.QueryString["REQUISITION_CODE"]); rgdHoldLog.DataBind(); DataTable dtCancel = BLL_PURC_Common.GET_ReqsnPermanentCancelLog_DL(UDFLib.ConvertToInteger(Request.QueryString["Vessel_Code"])); if (dtCancel.Rows.Count > 0) { dtCancel.DefaultView.RowFilter = "REQUISITION_CODE='" + Request.QueryString["REQUISITION_CODE"] + "'"; } gvReqsnCAncel.DataSource = dtCancel.DefaultView; gvReqsnCAncel.DataBind(); if (dsAuditSumry.Tables[0].Rows.Count > 0) { lblReqNo.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["RequistionCode"]); lblTotalItem.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["TotalItems"]); lblToDate.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["ToDate"]); txtComments.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["ReqComents"]); lblDept.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["DeptName"]); } //Step 2 ReptrQtnSummry.DataSource = dsAuditSumry.Tables[1]; ReptrQtnSummry.DataBind(); //////Step 3 ReptrQtnEve.DataSource = dsAuditSumry.Tables[2]; ReptrQtnEve.DataBind(); //////Step 4 ReptrPurchaseOrd.DataSource = dsAuditSumry.Tables[3]; ReptrPurchaseOrd.DataBind(); //////Step 5 ReptrPendingSupConfirm.DataSource = dsAuditSumry.Tables[4]; ReptrPendingSupConfirm.DataBind(); //////Step 6 ReptrDeliveryStatus.DataSource = dsAuditSumry.Tables[5]; ReptrDeliveryStatus.DataBind(); //////Step 7 ReptrDeliveredItems.DataSource = dsAuditSumry.Tables[6]; ReptrDeliveredItems.DataBind(); }