Problem selecting records from table

Question

0.00/5 (No votes)

See more:

I want compare two set of records. One is dataset records and another is Sqltable records. I want get the sql record which is not in dataset records. Please help me anybody.
Thank you

[edit]SHOUTING removed - OriginalGriff[/edit]

Posted 12-Mar-12 6:26am

devausha

Updated 12-Mar-12 6:59am

OriginalGriff

v2

Add a Solution

Comments

[no name] 12-Mar-12 12:32pm

Can you please show some code/progress you made so far?

OriginalGriff 12-Mar-12 12:59pm

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

infinitizon 12-Mar-12 13:13pm

Dont know if this will help, but you may try copying your Sqltable records into another datatable, then compare the two datatables.

Check out:
http://stackoverflow.com/questions/164144/c-how-to-compare-two-datatables-a-b-how-to-show-rows-which-are-in-b-but-not
http://stackoverflow.com/questions/1259855/compare-two-datasets-in-c-sharp

Ganesan Senthilvel 12-Mar-12 21:43pm

Share your code for clarity

i_am_LemOn 13-Mar-12 0:23am

are you using stored procedure? or you want to get the table records straight from your code (front-end)?

1 solution

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)

Tarun Dutt · Accepted Answer · 2012-03-12T22:01:00

Solution 1

May this help you.

put your both records in two dataset then using a loop match each rows/column
then that records not matched then insert it into another temporary datatable/dataset.

Posted 12-Mar-12 22:01pm

Tarun Dutt