Hi everybody,

I am wondering what is the best way of re-writing the following logic in VFP into C#:

select 0
      create cursor csrMatch (pass_no B(0), invoice_no B(0), date_time T, inv_bal Y, availbonus Y, cashoutbal Y)

After that cursor is created, I get 10 rows from the SQL server. Then for each of these 10 rows the stored procedure is run and if one of the returned column is not 0 (the result of the procedure is a single row), the row is inserted into this cursor (row based on the first and second cursors).

And finally we format that csrMatch into XML string and return back.

So, my first question is how to simulate creating a cursor and inserting rows into it in C# and my second question (assuming I need to use datatable for the first) is how to convert datatable into SqlReader (if one can be converted into another) as I have methods what produce XML based on passed SqlReader.

Thanks in advance.