hi friends!
i want to upload the the excel sheet in to my table using the c# code.,am developing the webapplication using VS2005,C#.
am used bulkupload for this,it is uploading correctly,but it allows to upload the duplicate entries(exisiting data),
so that i want to check the whole excel sheet data Versus DatabaseTable data to avoid the duplicates/erros with the data.,
is there any way that, can i check the excel sheet data as row by row and checking the exisit with table.,that is i want to take one row from excel sheet,then want to check the same row is already exisit in the database.
so that before to upload i coulid check the whole excel file,if it correct it should upload.,if it has error datas the message has to throw which rows are contains the errro data to the user.
could any one give the suggestion.,
thanks in advace
|
| Author: Viggneshwar 20 Aug 2008 | Member Level: Silver | Rating:  Points: 3 |
One of the option is read the Excel data and insert into datatable.
another one is SQL have option to Inert Datas from Excel to selected Table. Try that
|