asp.net program is not executing

[swethasuresh]

helloo im swetha working in a software company and im a fresher so i got a problem in asp with vb.net program..
kindly solve my problem..in dis below program there is a error coming at execute non query.
so pls send me the solution...
thanking you,
swetha.

Imports System.Data
Imports System.Data.OleDb
 
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim objConn As OleDbConnection
    Dim txt_1 As Integer
    Dim txt_2 As String
    Dim txt_3 As String
    Dim strSQL As String
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim objCmd As OleDbCommand
        Dim strDSN As String
        strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
                     & Server.MapPath("db1.mdb")
        objConn = New OleDbConnection(strDSN)
 
        strSQL = "insert into user_master(user_id,user_name,user_pwd) values (" & txt_1 & " ,' " & txt_2 & ",'" & txt_3 & " )"
 
        objConn = New OleDbConnection(strDSN)
        objCmd = New OleDbCommand(strSQL, objConn)
 
        objCmd.Connection.Open()
        objCmd.ExecuteNonQuery()
        objCmd.Connection.Close()
 
 
        Response.Write("<h3>Record add¡G</h3>")
        Response.Write("Sucessfuly Record Inserted")
        Response.Write("</ul>")
 
 
    End Sub

[kenobewan]

Insert syntax incorrect, bad idea inserting id numbers...

[radcaesar]

Have a break point on ur strSQL and check that insert query.

[DrBunchman]

There are no single quotes around txt_1 in your insert statement which may be the cause of the problem. Also as Kenobewan says be careful that you are not trying to insert into an identity field.

Dr B