add new record to database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 456,195 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,943 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our VB.NET advertiser: Programming Forums

Thread Tools Display Modes

Views: 2648 | Replies: 1

•

Join Date: Oct 2006

Posts: 14

Reputation: lukis is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

lukis

Offline

Newbie Poster

add new record to database

May 8th, 2007

Hi there,

I have a form that adds a Customer to a database. I had set the cust_id in the Ms Access as an Autonumber. and when I open the vb form, i wrote a code that will set the textbox of the cust_id as the count of the records + 1. That is displayed correctly.

my problem is this. When I click on the button save i have the following code attached

Help with Code Tags

(Toggle Plain Text)

me.databinding(dataset11, "Customer").addnew()
oledb_Cust.fill(dataset11)

it's telling me that since the cust_id is a primary number, it's doesn't allow it to be null. Now i'm generating that number as i specified in the first paragraph.

any help?

Thanks
Luke