Greetings,

I am very new to VBasic and sure as hell newbie when it comes to database. I have learned just enough to design form, to do just basic calculation based on programmed formula. Recently I got Visual Studio 2008 Pro which has VBasic and different kind of database project along with many other projects that goes way over my head.

Anywho, after reading several tutorials from many website, FAQ, forums, etc. I am still stuck. My project consists of 2 sections. Users create/load profile. Then do a search for specific item by words (*strings*) , select the item from result list, and do some calculations. The 2nd section is for me (Admin) to add/remove/edit items to/from database. Here is my problem..

1) I am trying to figure out what my code should be in order to add/delete/update since most FAQ/Tutorial deal with VB6 and Access/MySQL or other things. There are too many Application versions, but none seem to include VStudio 2008 Pro guide. Not to mention after reading most of them tutorial, guide, etc confused me even more.

2) For user section I don't want to bind database to textbox since I want the user be able to select name/item from search query/list. Then load the appropriate data based on selected name to the textbox.

=========
The following things I use...
Since I have no clue about database, I selected Local Database which is MS SQL (not MySQL)

frmACCAdmin
CLTable ([ID], Name, Skill, Level, WL, Qty)
Craftlist.mdf
CraftlistDataSet.xsd

Following code for adding didn't work..

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.BindingContext(CraftlistDataSet, "CLTable").AddNew()
MsgBox("Successfully Inserted")
End Sub


All it does it give me pop up "Successfully Inserted" , but did not add given data to database. No error message of any kind, No error indicated in VS2008 coding/design window.

I appreciate your help and time. Thanks in advance, most likely will have more questions later. Just need to get over this bump.

Xad