[Solved] RadGrid Exporting to Excel more records than bound to the grid

[Matt]

I have a radgrid that I'm only binding 200 records to regardless of the total record count.  When exporting to Excel, I want to export the entire record set.  In the RadGrid1_ItemCommand event, I'm resetting the parameters for the SQLDataSource that drives the grid and am creating a view with the complete record set.  However, when the export occurs, only 200 records are exported.  How can export the entire set of records?

[Princy]

Hello Matt,

I have tried the export to excel with an example ,it works fine for me.
Please have a look at the code and see if it helps you.

C#:

SqlConnection conn = new SqlConnection(connection);
public SqlCommand SqlCommand = new SqlCommand();
DataTable dt1 = new DataTable();

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    string selectQuery1 = "SELECT top 10 [OrderID], [CustomerID], [EmployeeID], [OrderDate], [ShipName] FROM [Orders]";
    SqlDataAdapter adapter1 = new SqlDataAdapter(selectQuery1, conn);
    conn.Open();
    adapter1.Fill(dt1);
    conn.Close();
    RadGrid1.DataSource = dt1;
}

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.ExportToExcelCommandName)
    {
        string selectQuery1 = "SELECT [OrderID], [CustomerID], [EmployeeID], [OrderDate], [ShipName] FROM [Orders]";
        SqlDataAdapter adapter1 = new SqlDataAdapter(selectQuery1, conn);
        conn.Open();
        adapter1.Fill(dt1);
        conn.Close();
        RadGrid1.DataSource = dt1;
        RadGrid1.DataBind();
    }
}

Thanks
Princy