Oracle DB and VB.Net help!!

FutureZone

New member
Joined
Nov 20, 2005
Messages
2
Programming Experience
Beginner
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

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,579
Location
Sydney, Australia
Programming Experience
10+
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.
 
Top Bottom