public void BindDropDwon()
{
DS = BindCommanData.BindCommanDropDwon("EmployeeID", "EmployeeCode as Code,EmployeeName as Name", "EmployeeMaster", "EmployeeID is not null");
DS.Tables[0].Columns.Add("StreetAndPlace", typeof(string), "Code +'-'+ Name");
dpASOID.DataSource = DS;
dpASOID.DataTextField = "StreetAndPlace";
dpASOID.DataBind();
dpASOID.Items.Insert(0, new ListItem("--Select ASOID --", "0"));
DS = BindCommanData.BindCommanDropDwon("CenterID ", "CenterCode +' '+CenterName as Name ", "tbl_MilkCollectionCenter", "IsActive=1 ");
if (!Comman.Comman.IsDataSetEmpty(DS))
{
dpCenter.DataSource = DS;
dpCenter.DataBind();
dpCenter.Items.Insert(0, new ListItem("--Select Center --", "0"));
}
//DS = BindCommanData.BindCommanDropDwon("Distinct QCat as Name ", "ID", "Proc_tblIncentiveTariff", "IsActive=1");
//if (!Comman.Comman.IsDataSetEmpty(DS))
//{
// dpIncentiveTariff.DataSource = DS;
// dpIncentiveTariff.DataBind();
// dpIncentiveTariff.Items.Insert(0, new ListItem("--Select Incentive Tariff --", "0"));
//}
DS = BindCommanData.GetIncentiveTariff("Distinct QCat as Name", "Proc_tblIncentiveTariff");
if (!Comman.Comman.IsDataSetEmpty(DS))
{
dpIncentiveTariff.DataSource = DS;
dpIncentiveTariff.DataBind();
dpIncentiveTariff.Items.Insert(0, new ListItem("--Select Incentive Tariff --", "0"));
}
DS = BindCommanData.GetCategory("Category as Name", "Proc_RawMilkTarrif");
if (!Comman.Comman.IsDataSetEmpty(DS))
{
Category.DataSource = DS;
Category.DataBind();
Category.Items.Insert(0, new ListItem("--Select Rawmilk Tariff --", "0"));
}
}