how to export datagrid data into excel ??

Find the article here which describes you to how to export it from windows application http://www.dotnetspider.com/technology/kbpages/950.aspx You many need Microsoft Excel 10.0 Object library, which can be downloaded from microsoft website.

Hi, thank you but, If i m not wrong,You have given code but it is for web. I need code that work on windows application. OR guide me how to get Response. ? thank you, bhavin

Here is the code for exporting data to excel. Response.ContentType="application/vnd.ms-excel"; Response.ContentEncoding=System.Text.Encoding.Default; Response.Charset = ""; this.EnableViewState=false; // dg is the name of the datagird dg.HeaderStyle.CssClass = "subhead"; dg.DataSource=ds.Tables[0].DefaultView; dg.DataBind(); System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw); dg.RenderControl(hw); Response.Write(tw.ToString()); Response.End();