Retriving data from data table if it contains more than one table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

i hv made a stored procedure in MSsql 2005 which contains four select statments for retriving data from four different tables. now i m using the stored procedure in my web application (asp.net with c#). how can i get access to data in the form of different tables retrived by the procedure if i have to pass them as datasource to four different datalists. Please Suggest something ,so that i have not to made four different procedures for four different select statements and the data fetched by single procedure can be easily bind to four different datalists simultaneously.
Thanx

stored procedure is:

SQL

ALTER PROCEDURE [dbo].[sp_select_interest]
    -- Add the parameters for the stored procedure here
    ( @uid int
)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    -- Insert statements for procedure here
    select music_liked.uid,music_liked.music_id,music.music_pic from music_liked,music where music_liked.music_id = music.music_id and music_liked.uid = @uid
    select movies_liked.uid,movies_liked.movies_id,movies.movies_pic from movies_liked,movies where movies_liked.movies_id = movies.movies_id and movies_liked.uid = @uid
    select books_liked.uid,books_liked.books_id,books.books_pic from books_liked,books where books_liked.books_id = books.books_id and books_liked.uid = @uid
    select games_liked.uid, games_liked.games_id, games.game from games_liked,games where games_liked.games_id = games.games_id and games_liked.uid = @uid
END

Posted 23-Apr-11 4:57am

shikha_14

Updated 24-Apr-11 3:34am

v2

Add a Solution

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

**R. Giskard Reventlov** · Answer 1 · 2011-04-23T05:13:00

Solution 1

Start here: Populate a DataSet with multiple DataTable objects using multiple SELECT statements[^]: not great but it'll get you going.

Posted 23-Apr-11 5:13am

R. Giskard Reventlov

ambarishtv · Answer 2 · 2011-04-23T05:36:00

SQL

ALTER PROCEDURE [dbo].[sp_select_interest]
    -- Add the parameters for the stored procedure here
    ( @uid int,
      @Type varchar

)
AS
BEGIN
    
if @Type = 'Music'
begin
    select music_liked.uid,music_liked.music_id,music.music_pic from music_liked,music where music_liked.music_id = music.music_id and music_liked.uid = @uid
end
If @Type = 'Movies'
begin
    select movies_liked.uid,movies_liked.movies_id,movies.movies_pic from movies_liked,movies where movies_liked.movies_id = movies.movies_id and movies_liked.uid = @uid
end

if @Type = 'Books'
begin
    select books_liked.uid,books_liked.books_id,books.books_pic from books_liked,books where books_liked.books_id = books.books_id and books_liked.uid = @uid
end
.  
.
END