Click here to Skip to main content
15,889,428 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
in my sql stored procedure i'm using 2 select query and its showing 2 outputs separately(as two rows result) . In my code behind i'm taking the output using sqlreaderdata (sqlreaderdata dr). I'm getting first output value(using dr[0]...), but what i want is second output value. how will i get the second output value..

first select query result shows like

34 10 10

ie, columnone value=34, columntwo value=10 columnthree value=10



here dr[0]=34
dr[1]=10
dr[3]=10

second select query output

columnone

34:10:10

what i want is "34:10:10"...how will i get it.
Posted
Comments
Marcus_2 26-Jul-13 4:38am    
Why not divide the SP into two seperate PS's dependeing on what outpuy you want?

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900