Bulk Insert into Datagrid

[johnaregan]

Hi
I do not know if this is at all possible but I would like to be able to copy rows from say an excel spreadsheet and insert them into a datagrid. The datagrid will then be submitted to bulk update a SQL Server table.

Any pointers in the right direction would be greatly appreciated

John

 

[hamking01]

johnaregan: did u find a solution to this? I'm trying to do the same, but couldn't find anything through google.

 

[BG12424]

Will these links help...

Try searching on "Excel to .NET DataTable" in Google...

http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/VB_DOT_NET/Q_20972338.html

http://www.codeproject.com/dotnet/ExportExcelData.asp

regards,
Brian

http://www.gainesconsulting.com

The problem with doing something right the first time is that nobody appreciates how difficult it was.

 

[hamking01]

These articles don't deal with inputting the datagrid values that were from the excel into a database via ASP.net

 

[BG12424]

The point with the articles are that you can load excel data into a datatable, which then you can bind to a datagrid. Once you have data in the datatable, you can do whatever you like with the data at that point, but first let's get it into something the server controls can understand.

regards,
Brian

http://www.gainesconsulting.com

The problem with doing something right the first time is that nobody appreciates how difficult it was.