protected void bind() { string PO_ID = Request.QueryString["PO_ID"]; List <DAL_PurchaseOrder> PO_List = new List <DAL_PurchaseOrder>(); PO_List = obj.GetSinglePurchaseOrders(PO_ID); tb_PO_ID.Text = PO_ID; tb_PO_CompanyEmail.Text = PO_List[0].PO_CompanyEmail.ToString(); tb_CompanyName.Text = PO_List[0].PO_CompanyName.ToString(); tb_CompanyContact.Text = PO_List[0].PO_CompanyContact.ToString(); tb_CompanyAddress.Text = PO_List[0].PO_CompanyAddress.ToString(); lbl_To.Text = PO_List[0].PO_CompanyEmail.ToString(); // =============== Gridview ================= DAL_OrderItem item = new DAL_OrderItem(); DataTable ds; ds = item.GetAll_OrderItem(); gv_OrderItem.DataSource = ds; gv_OrderItem.DataBind(); gv_OrderItem.FooterRow.Cells[2].Text = "Total Amount"; gv_OrderItem.FooterRow.Cells[3].Text = ds.Compute("SUM(OI_Price)", "").ToString(); }
protected void bind() { string PO_ID = Request.QueryString["PO_ID"]; List <DAL_PurchaseOrder> PO_List = new List <DAL_PurchaseOrder>(); PO_List = obj.GetSinglePurchaseOrders(PO_ID); tb_PO_ID.Text = PO_ID; tb_PO_CompanyEmail.Text = PO_List[0].PO_CompanyEmail.ToString(); tb_CompanyName.Text = PO_List[0].PO_CompanyName.ToString(); tb_CompanyContact.Text = PO_List[0].PO_CompanyContact.ToString(); tb_CompanyAddress.Text = PO_List[0].PO_CompanyAddress.ToString(); lbl_To.Text = PO_List[0].PO_CompanyEmail.ToString(); // =============== Gridview ================= DAL_OrderItem item = new DAL_OrderItem(); DataSet ds; ds = item.GetAll_OrderItem(); gv_OrderItem.DataSource = ds; gv_OrderItem.DataBind(); }