private void BindDropdown() { BindDropdownDAL obj = new BindDropdownDAL(); var senderLst = obj.BindSender(); var receiverLst = obj.BindSender(); var TruckNolst = obj.BindTruckNo(); var ToCity = obj.BindAllToCity(); var Agent = obj.BindAgent(); var bank = obj.BindBank(); var itemname = obj.BindItemName(); var UnitName = obj.BindUnitName(); var Transpoter = obj.BindTranspoter(); obj = null; ddlSenderName.DataSource = senderLst; ddlSenderName.DataTextField = "Acnt_Name"; ddlSenderName.DataValueField = "Acnt_Idno"; ddlSenderName.DataBind(); ddlSenderName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlReciverName.DataSource = receiverLst; ddlReciverName.DataTextField = "acnt_name"; ddlReciverName.DataValueField = "acnt_idno"; ddlReciverName.DataBind(); ddlReciverName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlTruckNo.DataSource = TruckNolst; ddlTruckNo.DataTextField = "Lorry_No"; ddlTruckNo.DataValueField = "lorry_idno"; ddlTruckNo.DataBind(); ddlTruckNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddltoCity.DataSource = ToCity; ddltoCity.DataTextField = "city_name"; ddltoCity.DataValueField = "city_idno"; ddltoCity.DataBind(); ddltoCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlfromCity.DataSource = ToCity; ddlfromCity.DataTextField = "city_name"; ddlfromCity.DataValueField = "city_idno"; ddlfromCity.DataBind(); ddlfromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlTranspoter.DataSource = Transpoter; ddlTranspoter.DataTextField = "Acnt_Name"; ddlTranspoter.DataValueField = "Acnt_Idno"; ddlTranspoter.DataBind(); ddlTranspoter.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); }
private void BindDropdown() { BindDropdownDAL obj = new BindDropdownDAL(); var senderLst = obj.BindSender(); var receiverLst = obj.BindSender(); var TruckNolst = obj.BindTruckNowithLastDigit(); var ToCity = obj.BindAllToCity(); var Agent = obj.BindAgent(); var bank = obj.BindBank(); var UnitName = obj.BindUnitName(); var ToCityComp = obj.BindLocFrom(); obj = null; ddlSender.DataSource = senderLst; ddlSender.DataTextField = "Acnt_Name"; ddlSender.DataValueField = "Acnt_Idno"; ddlSender.DataBind(); ddlSender.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlTruckNo.DataSource = TruckNolst; ddlTruckNo.DataTextField = "Lorry_No"; ddlTruckNo.DataValueField = "Lorry_Idno"; ddlTruckNo.DataBind(); ddlTruckNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlFromCity.DataSource = ToCity; ddlFromCity.DataTextField = "city_name"; ddlFromCity.DataValueField = "city_idno"; ddlFromCity.DataBind(); ddlFromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlToCity.DataSource = ToCity; ddlToCity.DataTextField = "city_name"; ddlToCity.DataValueField = "city_idno"; ddlToCity.DataBind(); ddlToCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlCompFromCity.DataSource = ToCity; ddlCompFromCity.DataTextField = "city_name"; ddlCompFromCity.DataValueField = "city_idno"; ddlCompFromCity.DataBind(); ddlCompFromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); ddlCompFromCity.DataSource = ToCityComp; ddlCompFromCity.DataTextField = "City_Name"; ddlCompFromCity.DataValueField = "City_Idno"; ddlCompFromCity.DataBind(); ddlCompFromCity.Items.Insert(0, new ListItem("--Select--", "0")); }