hello
i am dispalying certain records from sql into datagrid.now i hav provided checkboxes in datagrid to select item.
now i want to transfer those selected item into excel sheet.
(1)i don't want all the rows in datagrid to be transferred to exported to excel ,only those rows who are selected by checkbox shud go to excel sheet.
(2)and in my datagrid iam displaying only certain cloumns from the table in sql,but i want to export all the columns of the particular row which was selected in datagrid.

help me with solution in vb.net

My suggestion is,
Create a dynamic Datagrid and populate it with the data from database based on your selection. Then export it to Excel on the fly as follows

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.No Cache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
this.ClearControls(datadrid);
datagrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();


Software proffesional from Bangalore,INDIA

Hi,
For the Excel functionality, there is a .net component called Spire.DataExport,Totally independent and not affiliated with and free download. I have heard that it is quite good for generating Excel files.
see: http://www.e-iceblue.com