Hi

Finnaly thks to al the ppl that look or reply my other questions and with luck I have made it this far with my program ^^

now i'm trying to insert value into my database
the only problem that is stoping me is that, in one of the coloumn (UserID) the values are set to auto number. as u can see i'm using the insert statment from the vb.net database wizzard and simply passing the values to the created insert statments.

So how can i add the last bit of code so that i can insert everything into my database?


Me.OleDbDataAdapter2.InsertCommand.Parameters("Name").Value = Me.regFullNameTxt.Text()
Me.OleDbDataAdapter2.InsertCommand.Parameters("LoginPassword").Value = Me.regPwdTxt.Text
Me.OleDbDataAdapter2.InsertCommand.Parameters("LoginName").Value = Me.regLogNameTxt.Text

Me.OleDbDataAdapter2.InsertCommand.ExecuteNonQuery()