>>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.
>
>Why not get all the data prepped on the backend before you even hit C#?
Someone just suggested me the same also. I already finished the method the first way (with two loops), but I am thinking that I probably should have taken the plug and written the above as a separate SP for the whole thing.
Although it probably would have been 2 similar SPs as we can pass either guest_no or number depending on some preference settings.
If it's not broken, fix it until it is.
My Blog