protected void btnLoadAll_Click(object sender, EventArgs e)
{
try
{
DataSet dsHeader = service.ExecuteSelectQuery("SOheader", " * ", "pSOHeaderID=" + txtSONumber.Text.Trim());
Session["HeaderDetail"] = dsHeader.Tables[0];
// Fill the header details in the table
Session["CustNo"] = txtCustNo.Text = hidCust.Value = dsHeader.Tables[0].Rows[0]["SellToCustNo"].ToString().Trim();
lblBill_Name.Text = dsHeader.Tables[0].Rows[0]["BillToCustName"].ToString().Trim();
lblBill_Contact.Text = dsHeader.Tables[0].Rows[0]["BillToContactName"].ToString().Trim();
lblBill_City.Text = dsHeader.Tables[0].Rows[0]["BillToCity"].ToString().Trim();
lblBill_Territory.Text = dsHeader.Tables[0].Rows[0]["BillToState"].ToString().Trim();
lblBill_Phone.Text = dsHeader.Tables[0].Rows[0]["BillToContactPhoneNo"].ToString().Trim();
lblBill_Pincode.Text = dsHeader.Tables[0].Rows[0]["BillToZip"].ToString().Trim();
lblUsageLoc.Text = dsHeader.Tables[0].Rows[0]["UsageLoc"].ToString().Trim();
lblShip_Name.Text = dsHeader.Tables[0].Rows[0]["ShipToName"].ToString().Trim();
lblShip_Contact.Text = dsHeader.Tables[0].Rows[0]["ContactName"].ToString().Trim();
lblShip_City.Text = dsHeader.Tables[0].Rows[0]["City"].ToString().Trim();
lblShip_Territory.Text = dsHeader.Tables[0].Rows[0]["State"].ToString().Trim();
lblShip_Phone.Text = dsHeader.Tables[0].Rows[0]["PhoneNo"].ToString().Trim();
lblShip_Pincode.Text = dsHeader.Tables[0].Rows[0]["Zip"].ToString().Trim();
lblBillCom.Visible = ((lblBill_City.Text.Trim() != "" && lblBill_Territory.Text.Trim() != "") ? true : false);
lblShipCom.Visible = ((lblShip_City.Text.Trim() != "" && lblShip_Territory.Text.Trim() != "") ? true : false);
}
catch (Exception ex) { }
}