private void BindHeader() { TechnicalBAL objtechBAL = new TechnicalBAL(); DataTable dts = new DataTable(); dts = objtechBAL.GetRequsitionDetails(Request.QueryString["VCode"].ToString(), Request.QueryString["ReqCode"].ToString(), Request.QueryString["ReqStage"].ToString()); if (Request.QueryString["ReqStage"].ToString() == "APR" || Request.QueryString["ReqStage"].ToString() == "ORD" || Request.QueryString["ReqStage"].ToString() == "DEO") { dts.DefaultView.RowFilter = "Order_Code='" + Request.QueryString["sOrderCode"].ToString() + "'"; } else if (Request.QueryString["ReqStage"].ToString() == "INV") { dts.DefaultView.RowFilter = "Delivery_Code='" + Request.QueryString["sDelivery"].ToString() + "'"; } if (dts.DefaultView.Count > 0) { lblFleet.Text = dts.DefaultView[0]["Tech_Manager"].ToString(); lblVessel.Text = dts.DefaultView[0]["Vessel_Name"].ToString(); lblDepartment.Text = dts.DefaultView[0]["Name_Dept"].ToString(); lblRequsition.Text = dts.DefaultView[0]["REQUISITION_CODE"].ToString(); lblCatalogue.Text = dts.DefaultView[0]["System_Description"].ToString(); Session["sDocCode"] = dts.DefaultView[0]["DOCUMENT_CODE"].ToString(); Session["sSystemCode"] = dts.DefaultView[0]["System_Code"].ToString(); } }