i have two tables,how can u show them together in datagridview?

Question

1.00/5 (1 vote)

See more:

VB

SQL

SQL-Server-2008

i have two tables ,how can i show them together in datagridview?

Posted 17-Feb-14 6:03am

Member kavyansh

Add a Solution

Comments

Ziee-M 17-Feb-14 12:35pm

you can't show 2 table in the same grid. however, you can parse your two table elements objects to same object type, and then put all in a unique datagrid.

Sergey Alexandrovich Kryukov 17-Feb-14 13:19pm

Same way as one. What's the problem?
—SA

2 solutions

Solution 1

I'm not sure what you mean, but...
DataSource[^] property of DataGridView[^] (DGV) accepts DataTable[^] object. It means you can fetch data from different tables in one query:

SQL

SELECT t1.*, t2.*
FROM t1 INNER JOIN t2 ON t1.key = t2.key

But if you use GridView[^] (ASP.NET) and want to display related records on another GV, please read about nested gridview[^].

Posted 17-Feb-14 7:21am

Maciej Los

Comments

Member kavyansh 23-Feb-14 7:28am

ok let me explain again,i have two table not linked with each other as both tables have nothing in common.but at last of all i want is this two tables can represented in datagridview.
just this two tables should be displayed in datagridview.
thank you for helping me out :-)

Maciej Los 23-Feb-14 16:53pm

It's not possible to display data from 2 tables in the same time in a single Datagridview if they have nothing in common (they're not related).

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-02-17T07:26:00

Solution 2

If both the Tables have same structure, then you can merge them and bind to the DataTable.

Refer answers at load 2 datatables in a datagridview[^].

Posted 17-Feb-14 7:26am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member kavyansh 23-Feb-14 7:22am

No,both tables dont have same structure..both tables have different number of columns..so is it still possible to merge them ?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 23-Feb-14 9:49am

How would you merge? Think of it once. First table have col1, but table don't have col1, but have col2.
How the data will be represented. So, change your logic or requirement,

Member kavyansh 1-Mar-14 12:13pm

You are correct...i was thinking wrong with respect to logic...absolutely both table should have same structure..
thanks for helping me out.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 1-Mar-14 13:56pm

No problem. Most welcome buddy. Keep coding. :)