How to send two different column names comes from to different tables from storeprocedure to ?

Question

0.00/5 (No votes)

See more:

Hiii,

SQL

select Id,DescName from A
    where CompanyId=@CompanyId
    select TypeName,Id as TypeId from B
    where CompanyId=@CompanyId

this is what i am returning from storeprocedure and assgining to list in my class file.

but in list i am getting only two columns of first table that is A but not from table B..

Posted 25-Aug-13 19:26pm

Torakami

Add a Solution

Comments

Nandakishore G N 26-Aug-13 1:37am

use join to accomplish this task.

Torakami 26-Aug-13 1:57am

If i join it , then from B it will return same data twp times ... as i have to give relation in join .. i simply want to return this first column .. and assign it to dropdowns using list

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)

_Asif_ · Answer 1 · 2013-08-25T19:36:00

Solution 1

Check this link

Stored procedures and multiple result sets in T-SQL[^]

Posted 25-Aug-13 19:36pm

_Asif_