Hello, i am looking for a solution to convert a list or any kind of DataSet into an dynamic result for stored procedure in SQLAnywhere 12. Until today I even didn't managed it to make the sample examples work. Best Regards asked 11 May '12, 06:55 DavidSteiman Mark Culp |
hello, we managed it to find the answer to this question.
and this is it! answered 14 May '12, 12:29 DavidSteiman |
I don't think the example works because of the missing data types in the column descriptions. See this post for a working example on SQLA 16. answered 17 Jun '15, 06:50 Michael Fischer Hm, I'd think the data type of the DataTable.Columns will default to string unless specified otherwise, and SQL Anywhere should be able to convert the real contents to int (as specified in the CREATE PROCEDURE result set). - That's just guesswork on my part:)
(17 Jun '15, 07:22)
Volker Barth
Replies hidden
1
It works in some situations and crashes in others. It might depend on the actual .NET Type of the DataReader column, the expected data type at SQLA, the .NET framework version used and probably moon phase and humidity. I never found out the exact combinations when it worked and when not. Always providing correct data types seems to have solved the issue for me.
(17 Jun '15, 13:49)
Michael Fischer
|
You mean the resultset for an external stored procedure which is written in .net?
exactly
the aim is to generate any kind of data in c#, then pass it to the database as an result.
I found only examples of ResulSet, which were fetched inside of c#.....like i call procedure "A" and in the implementation of "A" stands an SQL Query. Beside the fact, that I didn't managed it to make it work, the samples aren't that what I'm looking for.
I believe, there must be a standard way of generating results in C#.....hope someone could help me.