emaduddeen
Programmer
Hi Everyone,
I have been reading that placing all SQL queries into ref cursors is more secure than having them float around the Visual Basic exe file.
That is way I would like to know how to load data from an Oracle ref cursor into a datagrid.
For now I would use the scott, tiger default Oracle database and have created a package called pkg_emad and a procedure called data_from_dept_and_emp and the ref cursor would be called dept_and_emp_ref_cursor.
Maybe it needs to be loaded into a dataset first then into the datagrid but I don't know how to do that either.
Ultimately, I would like to be able to insert, change and delete from the datagrid and have those changes reflected in the database.
Hopefully I'm not asking to much but any help will be a good learning experience for me.
Thanks.
Truly,
Emad
I have been reading that placing all SQL queries into ref cursors is more secure than having them float around the Visual Basic exe file.
That is way I would like to know how to load data from an Oracle ref cursor into a datagrid.
For now I would use the scott, tiger default Oracle database and have created a package called pkg_emad and a procedure called data_from_dept_and_emp and the ref cursor would be called dept_and_emp_ref_cursor.
Maybe it needs to be loaded into a dataset first then into the datagrid but I don't know how to do that either.
Ultimately, I would like to be able to insert, change and delete from the datagrid and have those changes reflected in the database.
Hopefully I'm not asking to much but any help will be a good learning experience for me.
Thanks.
Truly,
Emad
