Excel to DataGrid to Database
Posted on 2009-02-22
I am trying to take an excel sheet that has some numeric tables, export them to a datagrid and then on a submit click, I want to insert or update each of the rows in the datagrid to the database.
I know how to go from the excel sheet to a datagrid, but I am having trouble with the following:
1) Validating the data coming from the excel sheet to the datagrid.
2) Taking a valid datagrid and updating or inserting each row into a database.
Any help and code samples would be appreciated.