Adding data to database

[trevor.niemack]

Hello
I am currently learning VB.net and I am using the tutorial on VB
express. One of the tutorials is about adding a database and then
creating a visual input or amendment screen but event though I have
followed the tutorial and even redone all the steps I cannot get the
input to save into the data below is the code that currently exists
against the form.

Public Class Form1

Private Sub AddressBookBind ingNavigatorSav eItem_Click(ByV al sender
As System.Object, ByVal e As System.EventArg s) Handles
AddressBookBind ingNavigatorSav eItem.Click
Me.Validate()
Me.AddressBookB indingSource.En dEdit()

Me.AddressBookT ableAdapter.Upd ate(Me.Database 1DataSet.Addres sBook)
End Sub

Private Sub Form1_FormClosi ng(ByVal sender As Object, ByVal e As
System.Windows. Forms.FormClosi ngEventArgs) Handles Me.FormClosing

Me.AddressBookB indingSource.En dEdit()

Me.AddressBookT ableAdapter.Upd ate(Me.Database 1DataSet.Addres sBook)
End Sub

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'TODO: This line of code loads data into the
'Database1DataS et.AddressBook' table. You can move, or remove it, as
needed.

Me.AddressBookT ableAdapter.Fil l(Me.Database1D ataSet.AddressB ook)

End Sub
End Class

[gene kelley]

On 14 Mar 2006 06:16:40 -0800, "tr************ @za.syspro.com"
<tr************ @za.syspro.com> wrote:

Hello
I am currently learning VB.net and I am using the tutorial on VB
express. One of the tutorials is about adding a database and then
creating a visual input or amendment screen but event though I have
followed the tutorial and even redone all the steps I cannot get the
input to save into the data below is the code that currently exists
against the form.

Public Class Form1

Private Sub AddressBookBind ingNavigatorSav eItem_Click(ByV al sender
As System.Object, ByVal e As System.EventArg s) Handles
AddressBookBin dingNavigatorSa veItem.Click
Me.Validate()
Me.AddressBookB indingSource.En dEdit()

Me.AddressBook TableAdapter.Up date(Me.Databas e1DataSet.Addre ssBook)
End Sub

Private Sub Form1_FormClosi ng(ByVal sender As Object, ByVal e As
System.Windows .Forms.FormClos ingEventArgs) Handles Me.FormClosing

Me.AddressBookB indingSource.En dEdit()

Me.AddressBook TableAdapter.Up date(Me.Databas e1DataSet.Addre ssBook)
End Sub

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventAr gs) Handles MyBase.Load
'TODO: This line of code loads data into the
'Database1Data Set.AddressBook ' table. You can move, or remove it, as
needed.

Me.AddressBook TableAdapter.Fi ll(Me.Database1 DataSet.Address Book)

End Sub
End Class

Run the .exe file in the project's bin\debug folder a couple of times.
You should see saved changes.

The two lines in the FormClosing event are not necessary.

Gene

[trevor.niemack]

Hello Gene
Thank you for the help but could you probably give me a short
explaination as to why if I run the exe from with the bin/debug folder
will the changes be saved whereas if I do this from within the IDE the
changes do not get saved?
I did read something about the properties option to copy to output
directory that will allow the changes to be saved.

[gene kelley]

On 15 Mar 2006 03:48:17 -0800, "tr************ @za.syspro.com"
<tr************ @za.syspro.com> wrote:

Hello Gene
Thank you for the help but could you probably give me a short
explaination as to why if I run the exe from with the bin/debug folder
will the changes be saved whereas if I do this from within the IDE the
changes do not get saved?
I did read something about the properties option to copy to output
directory that will allow the changes to be saved.

The changes do actually get saved when running from within the IDE.
However, by default, the database file's property, Copy To Output
Directory, is "Copy Always". So, each time you run the project in the
IDE, the last working database file in the bin/debug folder gets
overwritten with the original database file, hence, it appears that
previous changes were not saved. The same applies with builds. Each
time you make a build, the original database file is copied to the
bin/release folder.

Changing "Copy Always" to Copy If Newer" will allow saved changes to
show when running in the IDE unless changes are made to the original
database file. If you are going to distribute the app, you need to
keep in mind whether you want the original or "current" database file
in the release.

Gene

[trevor.niemack]

Hello Gene
I do understand the concept and I have got it to work and as you
mentioned in your last statement the original database is being viewed
instead of the current. How can I change this?
Thanks for you time and help.