Datatable and dataset

Abhay Mhatre

Hello everyone, please help me....

I want to validate some isbn numbers from excel spreadsheet with my database values, currently I have more than 9000 records in my database. My approch was to grab every record from database and store it into dataset and then perform checking against each value. I have 1800 new records from excel spreadsheet, these records need to be checked agianst my database values, such that I should not add new entries if it alredy exist.
When I load my database record into dataset , it actually grabs only first 2888 records...

Please suggest me best possible approch for this kind of checking, also what is max amount of records a datatable can hold at a time.....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
Hi

The best thing is transfer these 1800 records into database and do the logic in Database i.e. Compare and insert. This is very simple compared to getting the data into Memory and doign the comparision.

Thanks -- Vj

http://dotnetvj.blogspot.com
0
Gaurav Tomar18y ago
Hi buddy,

Try paging to retrieve records into dataset from your database, it might helps you.

Also to know no. of records you get in dataset, check the above reply by "rahul kumar".

It will be helpful to you.

good luck
0