How to store password and date{} in visual basic 2010

See more:

Visual-Studio

i want create office application in visual basic 2010 with password and email id and contact mobile no , but it's split a err that " err in insert into " statement .
please help me to solves this.i was already write a dbcontrol.class code to connect access detabase and it run a perfectly.

yogesh vaidya

What I have tried:

Private Sub saveuserdata()
       access.execquery("select * from userdata ORDER BY username ASC")
       If NOTEMPTY(access.exception) Then MsgBox(access.exception) : Exit Sub
       'Add parameter
       'Add parameter
       access.addparam("@usernm", Textusername.Text)
       access.addparam("@pass", txtpassword.Text)
       access.addparam("@fnm", txtfirstname.Text)
       access.addparam("@lnm", txtlastname.Text)
       access.addparam("@email", txtemail.Text)
       access.addparam("@cont", txtcontact.Text)
       access.execquery("insert into a_sbupdate (username,[password],firstname,lastname,e-mail,mobaile_no) " & _
                       "values(@usernm,@pass,@fnm,@lnm,@email,@cont); ")

       If Not String.IsNullOrEmpty(access.exception) Then MsgBox(access.exception) : Exit Sub
       MsgBox("USER ADDED SUCCESSFULY !!! ,LOGIN TO PROSIDE MORE... ")
       Me.Close()
       Form1.Show()