Ohhh u got that right, in fact i knew that the "wrapper" are to be used here, but didn't know exactly where. thanks Charlie Sir

Thanks Andrew..

soryyyy i didnt specify..lol here it is ..

.InsertCommand.ExecuteNonQuery()

it gives me the syntax errror when i run the program

i've changed the sql in to Oledb..now it gives me this error..

"Characters found after end of SQL statement"

here are my codes:

    Private Sub btnLogin_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
        Dim con As New OleDb.OleDbConnection
        Dim cmd As New OleDb.OleDbCommand
        Dim adapter As New OleDb.OleDbDataAdapter
        Dim dataset As New DataSet

        con.ConnectionString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source = LibraryManagementSystemDatabase1.accdb; persist security info=false;"
        cmd.CommandText = "SELECT * FROM [Registration] WHERE username='" & txtUsername.Text & "' AND password='" & txtPassword.Text & "';'"

        con.Open()
        cmd.Connection = con

        adapter.SelectCommand = cmd
        adapter.Fill(dataset, "0")

        Dim count = dataset.Tables(0).Rows.Count

        If count > 0 Then
            welcomeForm.Show()
            Me.Hide()

        Else
            MsgBox("Incorrect username or password", MsgBoxStyle.Critical)
            txtUsername.Clear()
            txtPassword.Clear()
        End If


    End Sub

and i've attached an image also

Nope it still gives me the same error..even after restart.my database is in my debug folder of my program...what can i do?



CharlieMay