Hi,

   I m using export to excel. Its working fine if records in datagrid are less. But if records are large e.g above 2000 rows its not working.Giving messaga Dialogs must be user-initiated Export to excel.

My code is as below

SaveFileDialog dialog = new SaveFileDialog { Filter = "Excel files|*.xls", DefaultExt = "xls" };

bool? showDialog = dialog.ShowDialog();

if (showDialog == true)

{

using (Stream exportStream = dialog.OpenFile())

    {

             dataWorkbook.Save(exportStream);

               exportStream.Close();

     }

}

So please give solution for large data

Thanks,

Nandu