Using stored procedures and datasets

[Benjamin Horsleben]

Hey,

I am trying to utilize a stored procedure within Visual Studio. The first problem occurred when I tried to add a query through the DataSet, but when I try to select the actual SP from the list, VS crashes. As a work-around, I tried to implement the call myself (with cmd.CommandText = "call <procedure..>";). It calls the SP correctly, but it is not able to fill a datatable with the results (the SP runs a select, and the results have been confirmed through the command-line client).

I know SP's can be called from VS, because I modified it to inserting the inputs into a temporary table, which it did successfully. Is there a specific problem with retrieving results from selects run within SP's, and do anyone know of a work-around I could utilize until the DataSet-interface is fully functional?


I am using the Connector/Net 5.1.1 with built-in visual studio support (don't know the version of this). MySQL version is 5.0.41. Server-machines are fully patched XP Home, XP Pro and Vista Business.

Benjamin Horsleben