protected void ddlStore_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlStore.SelectedIndex > 0)
{
ddlBusiness.Items.Clear();
ddlBusiness.DataSource = ClsBusiness.SpBusinessMasterGetData();
//ddlBusiness.DataSource = obj.selectBusinessByCompany(Int32.Parse(Session["Comid"].ToString()));
string k1 = "SELECT BusinessMaster.BusinessID as businessid,BusinessMaster.BusinessName + ' : ' +DepartmentmasterMNC.Departmentname as businessname, BusinessMaster.DepartmentId FROM BusinessMaster inner join DepartmentmasterMNC on DepartmentmasterMNC.id=BusinessMaster.DepartmentId WHERE BusinessMaster.company_id = '" + Session["Comid"] + "' ORDER BY BusinessMaster.BusinessName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
DataTable dte = new DataTable();
adp1.Fill(dte);
ddlBusiness.DataSource = dte;
ddlBusiness.DataMember = "BusinessMaster";
ddlBusiness.DataTextField = "BusinessName";
ddlBusiness.DataValueField = "Businessid";
ddlBusiness.DataBind();
ddlBusiness.Items.Insert(0, "--Select--");
}
}
