Oracle DB and VB.Net help!!

[FutureZone]

Hi All,

Let's say I have a Oracle DB table called "Customer" and I can display all lists in VB.Net from that table data. If I want to add new record for customer how can I code into it? Cos I added on button labelled "Add".

I added this "OledbAdapter1.add(Dataset11) " code to button and it doesnet work. Any guides ? Sorry for silly question.

Thnks,

 

[jmcilhinney]

I strongly suggest that you read up on ADO.NET either at MSDN or one of the tutorial sites in my signature, and also check out the data access samples in the 101 samples. You need to call the Update method of the data adapter to delete, insert and update any changed rows, but you need to set up the adapater first. Also, I'd suggest using the OracleClient namespace instead of OleDb if you're using Oracle.

 

[FutureZone]

Hi Jm,

Thnks for your guide and will read up those links you advice.

Thnks,