how to get different columns from two tables

Question

0.00/5 (No votes)

See more:

Hi, I have two tables-
TABLE - projectpaymentschedule

COLUMN - ppsID,milestone,completiondate,billingdate,billingrupees,projectid

dataset ds1;

TABLE - projectpaymentreceipt-

COLUMN - pprID,receiptdate,receiptamount,projectid

dataset ds2;

C#

ds1.merge(ds2);

i want these columns in a grid view.

i take two data set and try to merge but output is comes in different rows.
like first data set data is comes in first row and second data set data is comes in second row.
if there is 2 rows in both tables i want data only in two rows.

Thanks in Advance.

Posted 16-Apr-12 18:57pm

mayankshrivastava

Add a Solution

3 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)

Vipin_Arora · Answer 1 · 2012-04-16T19:28:00

There are Several factors and options affect how new data is merged into an existing DataSet.Keep in mind the same..

following link may help you:

http://msdn.microsoft.com/en-us/library/aszytsd8.aspx[^]

http://stackoverflow.com/questions/9107231/how-to-merge-two-datatable-containing-different-column-based-on-condition[^]

U can Also Try with Same dataset and Diferent tables.
same as below link:

http://csharp.net-informations.com/dataset/dataset-merge-sqlserver.htm[^]

Mohamed Mitwalli · Answer 2 · 2012-04-16T19:54:00

Solution 2

Hi,
You can make it using T-SQL using INNER JOIN or union according to your business logic
Check here[^]
or
Check here[^]
Best Regards
M.Mitwalli

Posted 16-Apr-12 19:54pm

Mohamed Mitwalli

PJ003 · Answer 3 · 2012-04-17T04:32:00

Solution 3

C#

sbSql.Append("select a.milestone,a.completiondate,a.billingdate,a.billingrupees,a.projectid, b.receiptdate,b.receiptamount from projectpaymentschedule a join projectpaymentreceipt b on a.projectid = b.projectid where a.projectid = @projectid");

Posted 17-Apr-12 4:32am

PJ003

Comments

mayankshrivastava 18-Apr-12 1:23am

Hi, Thanx from reply.
but its not working properly.
if there s 2 rows in first table and 1 row in second table so it give two rows with repeat values of second table.