Hi there!
I've developed a program in C# that calls a stored procedure in SQL server. Is it possible for a stored procedure to pass back a result set with multiple rows? If so how do I access these values in my application.
Many Thanks!
sofia24
0
Newbie Poster
Recommended Answers
Jump to PostYes, you can hold what returned from your SP in XML object for later processing or DataReader for navigation..
If you need a sample tell me..
All 3 Replies
Ramy Mahrous
401
Postaholic
Featured Poster
Yes, you can hold what returned from your SP in XML object for later processing or DataReader for navigation..
If you need a sample tell me..
sofia24
0
Newbie Poster
Thanks! :) I can now access the result set.
Ramy Mahrous
401
Postaholic
Featured Poster
You're welcome, just drop any question at anytime!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.