oracle stored procedure & vb.net

[r4k35h]

Hi,
I would like to request a general code format in vb.net that would help me connect to oracle + get/set/del data from vb.net using stored procedure,which uses all three types of IN,OUT,IN OUT parameters.
It would be kind enough if an example for each the following can be given
1) for stored procedure with IN parameters only,
2) for stored procedure with IN & OUT parameters ,
3) for stored procedure with all parameters,


Thank You

 

[cjard]

Are you using the dataset designer in your work?

 

[r4k35h]

well no i want it to be done programatically i.e using codes

 

[cjard]

OK, heres the simple way: Use the dataset designer. When youre done, click SHOW ALL FILES on the solution explorer and open the code of the MyDataSet.Designer.vb

Find the code it wrote for you and copy/paste it out into wherever you want.. Its exactly the same code you would have written anyway

Do note that doing so isnt very good encapsulation practice.. youre copying code out of a "sensible place" -> the data abstraction layer.. and putting it into a "not sensible place" -> the button handler of a form or wherever...

It will work, it just violates OO design guidelines really.. Often, VB programmers in particular are least bothered about this because they are accustomed (from VB6) to dropping a button on a form, double clicking it and writing a huge block of code, that is nothing to do with GUI