how to get two table data at a time

Question

0.00/5 (No votes)

See more:

There are two table

1.registration
Id primary key auto increment
dealer name,
mobile,
dob etc.

2.product
userid primary key auto increment,
Posting type(which have two option sell and rent)
id foreign key
address,
city
price,locality

and a RadioButtonList with two items 1:Sell 2:Rent

I want that if sell is selected then retrieve dealer name and mobile from first table and address, city, price and locality from second table where condition is met with selected radio button.

Please help me?

Posted 29-Sep-11 1:30am

soniya sangal

Updated 29-Sep-11 1:42am

André Kraak

v3

Add a Solution

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

Sudhir Kumar Srivastava lko · Answer 1 · 2011-09-29T01:56:00

Use the Left outer join, where first table will be registration and second would be product,

problem with inner join if there is no matching record found in the second table then data will not be displayed,

read more about joins:

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

Hope this will help:

sujit0761 · Answer 2 · 2011-09-29T01:41:00

Solution 1

You have to use innerjoins in your SQL query if you need to retrieve data from 2 tables , be sure that these two tables are connected to each other with a primary key.

You can get a brief intro about inner joins in the link below.

http://www.w3schools.com/sql/sql_join_inner.asp[^]

Posted 29-Sep-11 1:41am

sujit0761

sravani.v · Answer 3 · 2011-09-29T01:42:00

In CheckeChanged Event of radio button, Write the query like this

SELECT R.dealer name,R.Mobile,P.address,P.city,price,P.locality FROM registration R INNER JOIN Product P ON R.Id=P.Id

If u want to get data from two tables you need join
Refer following links

http://www.w3schools.com/sql/sql_join_inner.asp[^]

http://msdn.microsoft.com/en-us/library/ms191517%28v=SQL.90%29.aspx[^]

Ram Balak Sharma · Answer 4 · 2011-09-29T02:40:00

Solution 4

Please claify you are writing directly queries or using and OR mapper like Like LinQto SQl or entity framework.

Posted 29-Sep-11 2:40am

Ram Balak Sharma

Muralikrishna8811 · Answer 5 · 2011-09-29T02:47:00

Solution 5

Hi,

try this query for your requirement.

C#

string query="select R.name,R.mobile,P.address,P.city,P.price,P.locality from registration as R,product as P where P.id=R.id and P.[Posting type]='"+Radiobtn.SelectedValue+"'";

All the Best

Posted 29-Sep-11 2:47am

Muralikrishna8811