Printable View
Hello,
i have to develop an application to compare a dataset (with around 1000s of records)with a database table which has almost more than 4 million records.
and if the dataset has matches in the table i will mark them as processed. is there any way to achive this .
Moved from the CodeBank
Just loop through them row by row. You'll create two loops, one to iterate through the largest dataset and the second to iterate through the smaller one.
Then just compare columns. If the column matches, compare the values. If all values from the smaller one match, mark it however you'd like.
I would suggest picking up a C# book as well. There may be a more built in way of doing this but I don't have much experience with a DataSet and this way should do just fine.
well the manual way ...i have done it already.. and it takes some time to process... i just want something much more easier..