Access, VB.NET, ADO.NET, Adding record

From: Maurice (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 01:41:07 -0800

I've been posting this question many times, thanks for the persons trying to help me but the solutions offered didn't work.

I want to build an Acces like form. Application starts, user sees a form with bound controls. The user can navigate through the records.
This is what I want to build but can't because it is obviously not possible in .NET:

- User presses the button "New record"
- The controls on the form become empty
- User fills in the fields
- User presses the button "Save record"
- Several checks will be done to see if user filled in correct
- Record is saved.

The solutions given to me are all about the same:

1. User presses button "New record", empty fields
Me.txtName.Text = ""
Me.txtLastname.Text = ""

2. Let user fill in the fields

3 Add record when user presses save
Dim Row As DataRow = dataset.Tables(0).NewRow()
Row("Name") = Me.txtName.Text
Row("Lastname") = Me.txtLastname.Text
dataset.Tables(0).Rows.Add(Row)

The problems is:
I want like in Acces show the user an empty record. What I'm actually doing is empty the fields of the current record and let the user fill in the new values. When I save, the values of the original record will be overwritten.

Does anyone know how to build an Access-like form in .NET?

Quantcast