protected void RadComboBox1_OnSelectedIndexChanged(object sender, EventArgs e) { string DMIDs = "9"; string comText = ""; var collection = RadComboBox1.CheckedItems; foreach (var item in collection) { //if (item.Selected) //{ DMIDs += ", " + item.Value; //} } comText = "select EmployeeID,EmployeeFullName from View_Employees where EmployeeType='DM' and DirectManagerID in(" + DMIDs + ")"; //comText = "select EmployeeID,EmployeeFullName from View_Employees where EmployeeType='DM' and DirectManagerID in(" + DMIDs + ") and lineID=" + ddlLine.SelectedValue; dsDM = new SqlDataSource(System.Configuration.ConfigurationManager.ConnectionStrings["AmounCRMConnectionString"].ConnectionString, comText); dsDM.SelectParameters.Add("DMIDs", TypeCode.String, DMIDs); DataView dv = (DataView)dsDM.Select(DataSourceSelectArguments.Empty); dsDM.DataBind(); RadComboBox2.DataSource = dsDM; RadComboBox2.DataValueField = "EmployeeID"; RadComboBox2.DataTextField = "EmployeeFullName"; RadComboBox2.DataBind(); }
protected void RadComboBox1_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { RLabel2.Visible = true; RadComboBox2.Visible = true; RadComboBox2.DataSource = GetData("spGetPassword", null); RadComboBox2.DataBind(); }
private void LoadData(string ProductName = "") { DAProduct daProduct = new DAProduct(); RadComboBox2.DataSource = daProduct.USP_Product_SearchByName(ProductName); RadComboBox2.DataBind(); }