Select From SQL database

Question

0.00/5 (No votes)

See more:

I am trying to select and display on the RadGrid. i am using sqlDataSource. i have 2 Tables (Users and DealerShip). User table i have attributes (UserID(pk),UserName,Email,Phoneand DealerShipID(fk)) on DealerShip table i have attributes (DealerShipID(pk),DealerShipName) and now here is what i want to do. on my grid i will have a drill down like a treeView, the DealerName will be like a masterview where you drill down you can find all the users that belong to that specific DealerShip, for example i will have three Dealers (a,b,c) which have different users under each, Business Rule (one user can only belong to i Dealership and one Dealership can have many users.) please can one assist on how to right a SELECT statement which will display all the users per Dealership?

Thanks.

Posted 16-Sep-15 22:07pm

Member 10528015

Add a Solution

Comments

F-ES Sitecore 17-Sep-15 5:11am

It's a SELECT with a JOIN. This is a very basic SQL question, google how to join tables for relevant articles.

Member 10528015 17-Sep-15 6:14am

HI i Know it is very basic query. here is query that i have: "SELECT Users.UserName FROM Users INNER JOIN DealerShip ON Users.UserID = DealerShip.UserID". The only problem is that it is displaying the sama names for all the Dealers

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)

John C Rayan · Answer 1 · 2015-09-17T01:57:00

Solution 2

SELECT Users.UserName,dealership.dealershipname FROM Users INNER JOIN DealerShip ON Users.delearshipid = DealerShip.dealershipID and dealership.dealershipid = @dealershipid

Posted 17-Sep-15 1:57am

John C Rayan