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"));
}
private void BindDropdown()
{
BindDropdownDAL obj = new BindDropdownDAL();
var senderLst = obj.BindSender();
var UnitName = obj.BindUnitName();
ddlunitname.DataSource = UnitName;
ddlunitname.DataTextField = "UOM_Name";
ddlunitname.DataValueField = "UOM_idno";
ddlunitname.DataBind();
obj = null;
ddlunitname.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
obj = null;
ddlSender.DataSource = senderLst;
ddlSender.DataTextField = "Acnt_Name";
ddlSender.DataValueField = "Acnt_Idno";
ddlSender.DataBind();
obj = null;
ddlSender.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}