save in a database

[=?Utf-8?B?RWR3YXJk?=]

Hi everybody
I'm usuing the walkthrough example in MSDN , I successfully created a SQL
database and I can retrieve my data in my application using bound controls
and Binding navigator but when I save something i the datebase and close the
application and then open it again all the new data i have saved are gone.
Even I added the code in my formclosing event
Me.AddressesBindingSource.EndEdit()
Me.AddressesTableAdapter.Update(Me.FirstDatabaseDa taSet.Addresses)
and results are the same.
Could be this because I dont have admin access to my computer at work? or
there is something Im missing here?

--
Best regards,
Edward

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Edward,

Could it be that you are updating a copy of your database? For example:

http://msdn.microsoft.com/en-us/library/ms246989.aspx

Kerry Moorman
"Edward" wrote:

Hi everybody
I'm usuing the walkthrough example in MSDN , I successfully created a SQL
database and I can retrieve my data in my application using bound controls
and Binding navigator but when I save something i the datebase and close the
application and then open it again all the new data i have saved are gone.
Even I added the code in my formclosing event
Me.AddressesBindingSource.EndEdit()
Me.AddressesTableAdapter.Update(Me.FirstDatabaseDa taSet.Addresses)
and results are the same.
Could be this because I dont have admin access to my computer at work? or
there is something Im missing here?

--
Best regards,
Edward

[=?Utf-8?B?RWR3YXJk?=]

Thank you, yes I did add a copy of the database in my project I’ll test
tonight the other way. I ‘m just puzzled why VB doesn’t update the copy of
the database which is in my project? In general which option is more useful?
I guess im not quite clear about those two ....
--
Best regards,
Edward
"Kerry Moorman" wrote:

Edward,

Could it be that you are updating a copy of your database? For example:

http://msdn.microsoft.com/en-us/library/ms246989.aspx

Kerry Moorman
"Edward" wrote:

Hi everybody
I'm usuing the walkthrough example in MSDN , I successfully created a SQL
database and I can retrieve my data in my application using bound controls
and Binding navigator but when I save something i the datebase and close the
application and then open it again all the new data i have saved are gone.
Even I added the code in my formclosing event
Me.AddressesBindingSource.EndEdit()
Me.AddressesTableAdapter.Update(Me.FirstDatabaseDa taSet.Addresses)
and results are the same.
Could be this because I dont have admin access to my computer at work? or
there is something Im missing here?

--
Best regards,
Edward