Simple Sample needed for loading and updating database

[fshrago]

I wrote many different database applications in VB6 but cannot seem to get my head round doing the same thing in .net

I have VB.NET 2005

I need a very simple application sample that takes a regular access database and displays the fields on a form and allows for update, new records and deleting.

Does anyone have any links to sample project that has all the details?

 

[cjard]

See my posting of SmarterHouse.zip in the Getting right record to fill dt thread over on ADO.NET forum

 

[fshrago]

I used some samples and put together the following code to save the data:

[SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE][SIZE=2] C2K_PurchasesBindingNavigatorSaveItem_Click([/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] sender [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.Object, [/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] e [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.EventArgs) [/SIZE][SIZE=2][COLOR=#0000ff]Handles[/COLOR][/SIZE][SIZE=2] C2K_PurchasesBindingNavigatorSaveItem.Click[/SIZE]
[SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].Validate()[/SIZE]
[SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].C2K_PurchasesBindingSource.EndEdit()[/SIZE]
[SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].C2K_PurchasesTableAdapter.Update([/SIZE][SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].Amazon_2003DataSet.C2K_Purchases)[/SIZE]
[SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE]

This saves the changes made ONLY for the duration the program is running, it does not save the data back to the database. What am I missing?

 

[cjard]

Read that thread I told you about. ckeezer makes the same complaint and i explain the ramifications of copy if newer/copy always. Youll understand when you read the thread