protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BCOShipper.DataSource = getBCO(); BCOShipper.DataTextField = "BranchCorpOfficeName"; BCOShipper.DataValueField = "BranchCorpOfficeName"; BCOShipper.DataBind(); BCOConsignee.DataSource = getBCO(); BCOConsignee.DataTextField = "BranchCorpOfficeName"; BCOConsignee.DataValueField = "BranchCorpOfficeName"; BCOConsignee.DataBind(); Shipmode.DataSource = getShipMode(); Shipmode.DataTextField = "ShipModeName"; Shipmode.DataValueField = "ShipModeName"; Shipmode.DataBind(); CommodityType.DataSource = getComtype(); CommodityType.DataTextField = "CommodityTypeName"; CommodityType.DataValueField = "CommodityTypeName"; CommodityType.DataBind(); ServiceMode.DataSource = getServiceMode(); ServiceMode.DataTextField = "ServiceModeName"; ServiceMode.DataValueField = "ServiceModeName"; ServiceMode.DataBind(); Paymode.DataSource = getPaymode(); Paymode.DataTextField = "PaymentModeName"; Paymode.DataValueField = "PaymentModeName"; Paymode.DataBind(); User.DataSource = getUser(); User.DataTextField = "FullName"; User.DataValueField = "FullName"; User.DataBind(); } }