I can see all the post is related to OLEDBconnection. But I am using SQL Server please let me know how to work with excel to data table or Gridview when I use sql server.
I can see all the post is related to OLEDBconnection
You use OLEDBConnection to retrieve data from EXCEL and most of the time you use SQLConnection to save/retrieve data from SQL Server.
santoshhegde
But I am using SQL Server please let me know how to work with excel to data table or Gridview when I use sql server.
So when you want to fill gridview from excel...you have to use OLEDBConnection and if it is SQL Server table you use SQLConnection
although OLEDBConnection can be used too but not advised.
Please mark the post as "Answer" that helps you.
Marked as answer by santoshhegde on Jan 25, 2013 08:21 AM
santoshhegde
Member
10 Points
23 Posts
Upload excel file(xls/xlsx) in asp.net c#
Jan 24, 2013 09:02 AM|LINK
Hi,
How to upload xls/xlsx file in c# asp.net and put excel data in repeater control. Please provide me a code to implement this.
Also for xls/xlsx upload do I need to install any thing in the IIS servers.
Thanks.....
me_ritz
Star
9337 Points
1447 Posts
Re: Upload excel file(xls/xlsx) in asp.net c#
Jan 24, 2013 09:05 AM|LINK
Let google do it for you : http://www.lmgtfy.com/?q=upload+and+read+excel+file+in+asp.net
santoshhegde
Member
10 Points
23 Posts
Re: Upload excel file(xls/xlsx) in asp.net c#
Jan 24, 2013 09:57 AM|LINK
Hi Thanks for your input my second question
For xls/xlsx/csv upload do I need to install any thing in the IIS servers. Not sure server is 2000 or 2003 or 2008........
me_ritz
Star
9337 Points
1447 Posts
Re: Upload excel file(xls/xlsx) in asp.net c#
Jan 24, 2013 10:08 AM|LINK
No...no need to install anything...
and one suggestion...please create separate thread for different issues
santoshhegde
Member
10 Points
23 Posts
Re: Upload excel file(xls/xlsx) in asp.net c#
Jan 25, 2013 05:46 AM|LINK
Hi ,
I can see all the post is related to OLEDBconnection. But I am using SQL Server please let me know how to work with excel to data table or Gridview when I use sql server.
Thanks...
me_ritz
Star
9337 Points
1447 Posts
Re: Upload excel file(xls/xlsx) in asp.net c#
Jan 25, 2013 05:57 AM|LINK
You use OLEDBConnection to retrieve data from EXCEL and most of the time you use SQLConnection to save/retrieve data from SQL Server.
So when you want to fill gridview from excel...you have to use OLEDBConnection and if it is SQL Server table you use SQLConnection although OLEDBConnection can be used too but not advised.