TableAdapter.Update with stored procedure
I've got a designer generated DataTable that uses a stored procedure to retrieve info from a table using a ref cursor.
I use the tableAdapter.Fill method and I can get the required values in my data table and use that in a datagridview.
Now I want to add another SP to the DataTable's update method so that when someone edits the values in the grid
I can save those changes back to my database as I would with a normal DataTable using TableAdapter.Update(DataSet.DataTable).
The problem is, from what I've read, I can't pass a DataTable to an oracle stored procedure because I can't create a ref
cursor in C#. What would be the best way to do this? I've read that I should use either Array Binding or XML, but how would
I go about doing this, keeping in mind that I would still like to use the designer to create typed datasets.
I'm using ODP.net, Oracle 11g database, Visual studio 2008
Thanks