Select From SQL database

Fulufhelo Munyai

11y1.1kSQL

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.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Fulufhelo Munyai11y ago
Sujeet Suman,

its fine whenever you have time you can help.

Thank You.
Sujeet Suman11y ago
Fulufhelo right now I am busy in my official work. So please give me some time. I will get back to you.
Fulufhelo Munyai11y ago
Hi for your Question "One thing how you are showing DealerShipName where as this is not present in your select query" i am using two Different SqlDataSource.

see attache output and the two Different SqlDataSource.

Thanks
Sujeet Suman11y ago
Please once try this query.

SELECT Users.UserName, DealerShip.DealerShipName FROM Users
INNER JOIN DealerShip ON Users.UserID = DealerShip.UserID
Group By DealerShip.DealerShipName

I think you are making mistake during binding. So please one debug your code.

One thing how you are showing DealerShipName where as this is not present in your select query.
Fulufhelo Munyai11y ago
Sujeet Suman,

See the screen shot of SQL Server Result Window.

Thanks.
Sujeet Suman11y ago
Please execute below query in your SQL Server.

SELECT Users.UserName FROM Users
INNER JOIN DealerShip ON Users.UserID = DealerShip.UserID

Then send me your screen shot of SQL Server Result Window.
Fulufhelo Munyai11y ago
HI Sujeet Suman,

Thanks for your reply but it is still giving me the same User for all the DealerShip whereas the is deferent users for each Dealer.

See attached File.

Thanks
Sujeet Suman11y ago
Your table & attributes are:
Users: (UserID(pk),UserName,Email,Phoneand DealerShipID(fk))
DealerShip: (DealerShipID(pk),DealerShipName)

Your query:
SELECT Users.UserName FROM Users
INNER JOIN DealerShip ON Users.UserID = DealerShip.UserID

So how you can compare with UserID. Because your table don't having UserID.

Please use this:
SELECT Users.UserName FROM Users
INNER JOIN DealerShip ON Users.DealerShipID = DealerShip.DealerShipID

If this is useful for you, then please accept my Answer..........
Fulufhelo Munyai11y ago
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.

attached is the Screenshot of the output that i am currently getting, maybe you can understand it clearly and help.