I would like to add to my DataAdapter a stored Procedure
(right click --> add query --> use existing stored procedure)
I want the stored procedure to return all the rows of the EMP table
(select * from EMP) in order to fill the EMP DataTable.
is it possible? which data type should the stored procedure return?
can you show me an example?
Thanks
Aya
p.s.
I found the way to do it manualy, using ref cursor in your Help files.
However, this I can do without your product...
DataAdpter and StoredProcedure
Don't you confuse DataAdapter with TableAdapter?I would like to add to my DataAdapter a stored Procedure
You are correct. The type should be ref cursor. How can you add such stored proc without our data provider?I found the way to do it manualy, using ref cursor in your Help files.
However, this I can do without your product...
1) you right, I meant TableAdapter.
How can I use Stored Procedure that return all the EMP table rows using the tableAdapter wizard.
2) the fill method is supported by OracleDataAdapter as you can see in this link
http://msdn2.microsoft.com/en-us/librar ... S.80).aspx
How can I use Stored Procedure that return all the EMP table rows using the tableAdapter wizard.
2) the fill method is supported by OracleDataAdapter as you can see in this link
http://msdn2.microsoft.com/en-us/librar ... S.80).aspx