or
I have a RadGrid and I’m experiencing very slow searching in the filtering. If I do a query on the server itself with a “select * from table where column LIKE ‘%blah%’ it can return the query in about a second. With the filtering it can take up to 20 seconds.
Is there a way to speed that up?
<Columns> <telerik:GridClientSelectColumn UniqueName="checkboxColumn"> </telerik:GridClientSelectColumn>foreach (GridDataItem item in radGrid.MasterTableView.Items){ if (item is GridDataItem) { for (int i = 1; i < renderedColumns; i++) { GridColumn column = radGrid.MasterTableView.RenderColumns[i]; Control control = item[column.UniqueName].Controls[0]; if (condition==true&&column.uniqueName=="checkboxColumn") { (control as CheckBox).Enabled=false; } (control as CheckBox).Enabled=false; to say: (control as CheckBox).Tooltip="test"; checkboxes also dissapear.GridTemplateColumns to it. Those columns have textbox in them.protected void Page_Init(object sender, EventArgs e) { DefineGridStructure();
}
protected void Page_Load(object sender, EventArgs e)
{
if (RadGrid1 != null && RadGrid1.Items.Count > 0)
{
string strtxt = ((TextBox)RadGrid1.Items[1]["ProductGroup1"].Controls[0]).Text;//For starters, load one control and check it's state
}
}
private void DefineGridStructure() { RadGrid1 = new RadGrid(); RadGrid1.AutoGenerateColumns = false; RadGrid1.ShowHeader = true; RadGrid1.NeedDataSource += RadGrid1_NeedDataSource; foreach(GridColumn qtyColumn in BuildGridQtyColumns(PaxColumnCount)) { RadGrid1.MasterTableView.Columns.Add(qtyColumn); } //Add grid to page phRadGrid.Controls.Add(RadGrid1); } private List<GridColumn> BuildGridQtyColumns(int count) { List<GridColumn> qtyColumns = new List<GridColumn>(); for (int i = 1; i <= count; i++) { string qtyColumnName = string.Format("ProductGroup{0}", i); GridTemplateColumn qtyColumn = new GridTemplateColumn(); qtyColumn.ItemTemplate = new GridNumberTemplate(qtyColumnName);//Creates a textbox control qtyColumn.UniqueName = qtyColumnName; qtyColumn.HeaderText = "Qty"; qtyColumn.HeaderStyle.Width = Unit.Pixel(60); qtyColumn.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; qtyColumns.Add(qtyColumn); } return qtyColumns; }CheckBox headerCheckBox = (sender as CheckBox);foreach (GridDataItem dataItem in this.radgridmailinglists.MasterTableView.Items){(dataItem.FindControl("chxselectrow") as CheckBox).Checked = headerCheckBox.Checked;dataItem.Selected = headerCheckBox.Checked;}