Member Avatar for sofia24

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!

  • 2 Contributors
  • 3 Replies
  • 83 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

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..

Member Avatar for sofia24

Thanks! :) I can now access the result set.

Member Avatar for Ramy Mahrous

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.