I would like to suggest that the Buttons in the RadGrid allow databinding to the CommandName and CommandArgument fields.  And pretty much all the buttons or anything that triggers an ItemCommand event that allow a CommandName and CommandArgument have their properties to be databound and accessible in the code behind.

Thanks!!!

A valid SQL statement should look like

SELECT * FROM Products WHERE ([Discontinued] = 1)

or

SELECT * FROM Products WHERE ([Discontinued] = 'True')

but RadGrid provides something like

([Discontinued] = True)

in the MasterTableView.FilterExpression property.

By default RadGrid filters the data on its own after retrieving the entire data set form the data source, and the filtering operation works like that.
If you will be using the filter expression provided by the grid in a custom data source operation you may need to tweak the string first.
Note that changing this may result in a breaking change if you are already using the current syntax.

Workaround: https://www.telerik.com/support/kb/aspnet-ajax/grid/details/get-sql-compliant-filterexpressions-from-radgrid

You would get something like

(([createddate] >= '01/08/2017,00:00:00') AND ([createddate] <= '14/08/2017,23:59:59'))

while you should get something like

(([createddate] >= '01/08/2017 00:00:00') AND ([createddate] <= '14/08/2017 23:59:59'))

so that the SQL syntax is valid.

RadGrid, does not send the FilterExpression to the SqlDataSource, however. It executes the SELECT statement and then filters the resulting data on its own. This works fine.

If you will be performing operations yourself, you could use a string operation before passing the filter expression. For example:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
	if (!string.IsNullOrEmpty(this.RadGrid1.MasterTableView.FilterExpression))
	{
		if (this.RadGrid1.MasterTableView.FilterExpression.Contains("createddate"))
		{
			this.RadGrid1.MasterTableView.FilterExpression = this.RadGrid1.MasterTableView.FilterExpression.Replace(",", " ");
		}
		DataView dv =GetData("select * from [myTable] where ", this.RadGrid1.MasterTableView.FilterExpression);
                //where you would need to have something like (([createddate] >= '01/08/2017 00:00:00') AND ([createddate] <= '14/08/2017 23:59:59'))
		this.RadGrid1.DataSource = dv;
	}
}

Note that implementing such a change may break existing code that relies on the current syntax that contains the comma.

Simply add a Column to RadGrid in the GridColumn Collection Editor of the Configuration wizard. You will note that a value for FilterControlAltText is autopopulated. When you hit Ok, that value is written in the column definition, in markup. If you clear that text in the editor, then, in markup you will find the value FilterControlAltText ="". This is useless clutter, which you should manually remove from the markup. The editor/designer should remove the property entry from markup if you clear the FilterControlAltText from the PropertyGrid in the GridColumn Collection Editor.

To overcome this issue you can do the following:

- For anchor links (a) implement onclick event with window.location.
- For submit buttons set UseSubmitBehavior property to false.

Workaround for the NextPrevAndNumeric mode is to set the AssociatedControlID of the label

	protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
	{
		if (e.Item is GridPagerItem)
		{
			GridPagerItem pager = e.Item as GridPagerItem;
			Label lbl = pager.FindControl("ChangePageSizeLabel") as Label;
			Panel pnl = lbl.Parent as Panel;
			RadComboBox combo = pnl.FindControl("PageSizeComboBox") as RadComboBox;
			lbl.AssociatedControlID = combo.ID;
		}
	}

	<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" AllowSorting="True"
						AllowPaging="True" GridLines="None" Width="100%" OnItemDataBound="RadGrid1_ItemDataBound">
		<PagerStyle Mode="NextPrevAndNumeric" Position="TopAndBottom" PageSizeControlType="RadComboBox"></PagerStyle>
	</telerik:RadGrid>
			
	<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
						ProviderName="System.Data.SqlClient" SelectCommand="SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, PostalCode FROM Customers"
						runat="server"></asp:SqlDataSource>

Would be nice to have RadGrid offer the feature to have options to Merge Cells with same contents so the report/grid won't be so busy. Users typically expect this kind of look and feel. 

Example & code included:
    http://www.marss.co.ua/2010/01/how-to-merge-cells-with-equal-values-in.html

This ticket discussed it also: 1091013

Others in forums asked about this also in the past since about 2009, if we google on: telerik grid asp.net merge cell. .
http://www.telerik.com/forums/problems-with-merge-row-in-radgrid

http://www.telerik.com/forums/merge-cells-by-column

http://www.telerik.com/forums/merge-rows

Then I found this link among the results from google. Though, I wish there are RowMerge and ColumnMerge properties in RadGrid for us to turn it on/off. That will be wonderful.

http://www.telerik.com/support/kb/winforms/details/radgridview-merge-celss

This example is also from the following link from the same google search result, the first link.

http://www.telerik.com/forums/merge-cell-in-radgrid

Thanks.

When using keyboard navigation, the ESC key currently does some things properly (like closing out of batch editing forms). However, it does not prevent the firing of certain update events (like BatchEditCellValueChanged). The ESC key should act like a "cancel" key, so no update events should fire when it is pressed.

The client-side KeyPress event is falling out of favor and the KeyDown even is being used more. Please implement an OnKeyDown event for the Grid, just like you currently have an OnKeyPress event

When in batch edit mode, using standard asp.net validation controls will display the validation error within the cell, and expand the cell contents horizontally and possibly vertically as well.  This is a very ugly (and clunky) way to show validation messages in a batch edit mode.  

It would be nice if instead, we could set an grid attribute that specifies a row backcolor when validation fails for a row.  In addition, show that rows validation messages automatically in a tooltip or radtooltip as the user hovers the mouse over the row when it signifies the exception backcolor.  These messages could be assigned to a columns markup as an attribute.   

Another nice to have is to show a  section on the grid (perhaps under the header) that could display to alert the user when validation had failed.

Property to disable the internal control state which is helpful in scenarios where ViewState is turned off.

This should resolve any problems when changing columns and datasource dynamically on PageInit, when sorting/filtering/etc is applied during the previous post.

In radgrid, the excel style filtering shows a checkbox list of values to filter a column.  This has limited use on a date + time column of a grid, because such a list would show basically every grid row value in the list.  I can bind date only to the filter checkboxes to shorten that list, but if I apply a selected checkbox to filter then there will be no records returned.  This checkbox filtering needs to work with the grid column attribute EnableTimeIndependentFiltering (when it is filtering a datetime column) but it does not - that attribute only works with the datepicker calendar and text entry.   

This feature request is regarding the ExportToExcel button in Radgrid.

ExportToExcel button in Radgrid adds an extra row in the exported excel sheet. This is due to the presence of Filtering items.

Export to Excel code in radgrid:

<ExportSettings ExportOnlyData="true" IgnorePaging="true" Excel-Format="Biff" OpenInNewWindow="True">
<Excel Format="Biff" AutoFitImages="True"></Excel>
        </ExportSettings>
<CommandItemSettings ShowAddNewRecordButton="False" ShowRefreshButton="False" ShowExportToExcelButton="True" ExportToExcelText="Export Grid To Excel"/>

The above code produces an extra row.

I know there is a fix by disabling the Filtering items in the grid in OnItemCommand event. So I used that. The code is given below:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
        {
            if (e.CommandName == RadGrid.ExportToExcelCommandName)
            {
                ReviewByCollegeGrid.AllowFilteringByColumn = false;
                ReviewByCollegeGrid.Rebind();
                ReviewByCollegeGrid.ExportSettings.Excel.Format = GridExcelExportFormat.Biff;
                ReviewByCollegeGrid.ExportSettings.IgnorePaging = true;
                ReviewByCollegeGrid.ExportSettings.ExportOnlyData = true;
                ReviewByCollegeGrid.ExportSettings.OpenInNewWindow = true;
            }
        }
But it is a lot of work when you have to do it for all the web pages in your application. Please provide a feature which will help to solve this issue in an easier way.

Please add support for tags in exported PDF documents. We need these tags for accessibility purposes. Currently, when we export a PDF from a RadGrid, it is created without any tag structure, which can make it difficult for a screen reader to process correctly.

Please add the ability to have a GridHyperLinkColumn automatically UrlEncode the fields specified in DataNavigateUrlFields. Having to handle it in the code-behind is a pointless pain in the butt, especially when dealing with more than 1 field. It should be handled automatically during the application of the DataNavigateUrlFormatString format instead.

RadGrid filtering issue when RenderMode is set to Mobile and the grid is bind on the client

See the movie below:
https://drive.google.com/file/d/0Bzhl0S7bXwuyYlZ1akFwdHZvWDg/view


This can be replicated in the online demo below when edit mode is set to Mobile:
http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/declarative/defaultcs.aspx