Insert Record in MS Access

See more:

VB

Hi!

I am trying to connect to MS access with vb.net using following steps:

1. Select "TOOL" from the menubar
2. Select "connect to database"
3. Enter the path of the database and click TEST CONNECTION. It will display the message "TEST CONNECTION SUCCESSFUL"

After that, I am writing some code in my form where I want to perform the insert query. The code is:

Imports System.Data.OleDb

Public Class Item_Info
    Dim cn As OleDbConnection
    Dim cmd As OleDbCommand
    Dim da As OleDbDataAdapter
    Dim dr As OleDbDataReader
    Dim str As String
    Dim icount As Integer

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
        cn = "here i am putting my database path.. connectionstring"
        cn.Open()
        str = "insert into Item_Master values('" & txtName.Text & "','" & txtCode.Text & "')"
        cmd = New OleDbCommand(str, cn)
        cmd.ExecuteNonQuery()
        cn.Close()

    End Sub
End Class

But when I run this form it doesn't create any output. Nor does it give any errors...... I don't understand what the problem is.
Please help me!