protected void RadGrid1_FilterCheckListItemsRequested(object sender, Telerik.Web.UI.GridFilterCheckListItemsRequestedEventArgs e) { MyASMXService service = new MyASMXService(); var y = service.GetCustomers(); if (e.Column is IGridDataColumn) { string dataField = (e.Column as IGridDataColumn).GetActiveDataField(); List <GridDataItem> list = new List <GridDataItem>(); switch (dataField) { case "CustomerID": e.ListBox.DataSource = y.Data.Select(x => new { text = x.CustomerID == "\0" ? "(blank)" : x.CustomerID, value = x.CustomerID }).Distinct().OrderBy(x => x.text); break; case "CompanyName": e.ListBox.DataSource = y.Data.Select(x => new { text = x.CompanyName == "\0" ? "(blank)" : x.CompanyName, value = x.CompanyName }).Distinct().OrderBy(x => x.text); break; case "GrowMeth": e.ListBox.DataSource = y.Data.Select(x => new { text = x.ContactName == "\0" ? "(blank)" : x.ContactName, value = x.ContactName }).Distinct().OrderBy(x => x.text); break; case "TypeCode": e.ListBox.DataSource = y.Data.Select(x => new { text = x.ContactTitle == "\0" ? "(blank)" : x.ContactTitle, value = x.ContactTitle }).Distinct().OrderBy(x => x.text); break; } e.ListBox.DataTextField = "text"; e.ListBox.DataValueField = "value"; e.ListBox.DataBind(); } }
protected void ReportGrid_FilterCheckListItemsRequested(object sender, Telerik.Web.UI.GridFilterCheckListItemsRequestedEventArgs e) { string DataField = (e.Column as IGridDataColumn).GetActiveDataField(); e.ListBox.DataSource = Data.GetDataFromSql(sql, DataField, DB); e.ListBox.DataKeyField = DataField; e.ListBox.DataTextField = DataField; e.ListBox.DataValueField = DataField; e.ListBox.DataBind(); }