C# in asp.netexcel

Question

INSERT INTO statement contains the following unknown field name: 'F2'. Make sure you have typed the name correctly, and try the operation again. using c#.net oledb

i need to insert record in excel using oldeb.i got above error

i have one gridview . i need to insert gridview column to excle column. and gridview rows are insert in to excel .

i got an above error . i use asp.net with c#. i need to use oledb object . export gridview to excel

Bhuvanesh Mohankumar · Answer

Hi Kumar you can accept my answer if that was useful. Thanks.

kumar yoga · Answer

thank you i use interop open the excel and write the content ij excel .when i publish web .the server excel file is not open.could not find www/inetpub/rootdirectory could not find the file.debug mode work fine.after publsih not work

alice yang · Answer

Hi As Bhuvanesh Mohankumar suggested you can bind the gridview to datatable and then export the datatable to excel. Check this thread which might helps: How to Export Datatable to Excel through DataGridView(using Oledb) http://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html

Bhuvanesh Mohankumar · Answer

I suggest you an alternate approach. Where get the data from grid and bind to the DataTable /DataSet You can easily export or write the content of table from Dataset to Excel. This is avoid the special character issues.

C# in asp.net,excel