Search Results from 2 tables Bind to Gridview

Question

0.00/5 (No votes)

See more:

Hi All,

I have a table T1 with columns c1,c2,c3 and T2 with c4,c5,c6.
And I want to search from two tables using c2 and c4 from both tables and I want to bind to Gridview.
And I want to display c1,c2,c4,c5 in Gridview.

Can any one tell me the code to bind to Gridview using 2 tables.
Thank you,

Posted 6-Jun-12 1:22am

jaipal0908

Updated 6-Jun-12 2:25am

v2

Add a Solution

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)

sunandandutt · Answer 1 · 2012-06-06T01:40:00

Solution 1

Try Join

Click Here:

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html[^]

Posted 6-Jun-12 1:40am

sunandandutt

taha bahraminezhad Jooneghani · Answer 2 · 2012-06-06T02:40:00

Solution 4

you need to merge two table in one,
if you have two table named dtOne and dtTwo this is the code:

C#

dtAll = dtOne.Copy();
dtAll.Merge(dtTwo,true);

Posted 6-Jun-12 2:40am

taha bahraminezhad Jooneghani

Sandeep Mewara · Answer 3 · 2012-06-06T01:44:00

Solution 2

Can any one tell me the code to bind to Gridview using 2 tables.
1. Grid can bind to one table at a time.
2. You need to form a SQL query that fetches the data from the two table
3. Use Foreign Key C1 to combine the two table and get a common result through a single query
4. Use this query result as a data source of your grid.

Now, Try! Post specific issue if you face any.

Posted 6-Jun-12 1:44am

Sandeep Mewara

Comments

jaipal0908 6-Jun-12 7:51am

Hi sandeep,
Sorry mistake in question post,There is no relationship is existing between two tables .Then can we bind?

Sandeep Mewara 6-Jun-12 9:15am

You can only bind grid with one datatable. So, you have to get whole data via query together.

AmitGajjar 6-Jun-12 8:24am

5+ correct.

**AmitGajjar** · Answer 4 · 2012-06-06T02:25:00

Solution 3

Hi,

you can use query something like this.

SQL

select T1.c1,T1.c2,T2.c4,T2.c5 from T1,T2 where T1.c1 = T2.c1 and T1.C2='searchString' and T2.c4='searchString';

Also see the Solution 2 given by Sandeep.

is it what you are looking for ?

Thanks
-Amit

Posted 6-Jun-12 2:25am

AmitGajjar