Hi,

I am using Sybase Anywhere 9.0.0 (1108) with C# application using
iAnywhere.Data.ASAClient

I refer this topic

ASA Programming Guide
Developing Applications with the .NET Data Provider

Using stored procedures

Question :
=======

1. I want one result set when i call stored procedure ( I know when you call
ExecuteReader that time it return resutl set)

2. In my procedure

Begin

loop
{
Select sum(mData) from table where date beetween this1 and this2;
}

//Every time this1 and this2 value change and loop rotate almost 70
times.
//I want to store this result in result set and finally return this
result set so i can use this in my //application
End


Ler me know How do i manuplate result set in stored procedure.