how to validate a set of data from database by hitting database only once ?

Question

2.00/5 (1 vote)

See more:

i have a set of values in a datatable . now i have to validate these data with my table in database . I dont want to hit the database one by one to verufy each datarow . Please suggest any method in which i can validate all theses data by hitting database only once .

Posted 19-Mar-12 19:24pm

prejval2006

Add a Solution

Comments

Mohamed Mitwalli 20-Mar-12 1:30am

hi
validate like see changes and apply it or what ?
please clarify .

prejval2006 20-Mar-12 1:37am

ya i have to check whether these are present in database .

Mohamed Mitwalli 20-Mar-12 1:48am

Hi,
One question?
means you need comparison from both of the table.
I need to know that you need to compare all the fields Or specific fields only.
please mention !!!!

Or mention the result you need

prejval2006 20-Mar-12 1:50am

no actually i am getting some data from excel which i have to verify whether it is present in database . And i have to verify only a single column .

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2012-03-19T19:29:00

Solution 1

If you know which SQL statements you're going to execute beforehand, you can bundle them into one call to the database, and return multiple result sets using ADO.NET

Posted 19-Mar-12 19:29pm

Ganesan Senthilvel

Saral S Stalin · Answer 2 · 2012-03-19T21:37:00

Solution 2

Send the dataset as an XML document to the database, use OPENXML in the stored procedure to convert it back to table format and do your validations. refer http://msdn.microsoft.com/en-us/library/ms186918.aspx[^]

Posted 19-Mar-12 21:37pm

Saral S Stalin

Updated 19-Mar-12 21:38pm

v2

kumarvinit86 · Answer 3 · 2012-03-19T21:55:00

Solution 3

bring the table in Ado.net store that table in a datatable and match with your existing table. that's it.

Posted 19-Mar-12 21:55pm

kumarvinit86

Mohamed Mitwalli · Answer 4 · 2012-03-19T22:13:00

Solution 4

hi 
u can bring data into datatable from database and u can add new columns Flag and for any record has been change u can mark this one as it changed 

i hope this solution satisfy your needs .

Posted 19-Mar-12 22:13pm

Mohamed Mitwalli