Insert query is not working access Vb.net

Question

My code is

Dim tmpSQL_2 = New StringBuilder
        tmpSQL_2.AppendLine("Insert into table(tbl_ID,tbl_Type,tbl_Type) ")
        tmpSQL_2.AppendLine(" VALUES ")
        tmpSQL_2.AppendLine("(@tbl_ID,@tbl_Type,@tbl_Type) ")
        Using tmpCMD As New OleDbCommand(tmpSQL_2.ToString, conn)
            tmpCMD.Parameters.AddWithValue("@tbl_ID", "0")
            tmpCMD.Parameters.AddWithValue("@tbl_Type", "my type")
            tmpCMD.Parameters.AddWithValue("@tbl_Ser_Id", "my type")
            tmpCMD.ExecuteNonQuery()
        End Using

for inserting into table but it is not working.

I'm not getting any error also. what should be the problem ?

matzone · Accepted Answer · 2013-07-29 07:42:23Z

1

Try it in defferent way ...

Dim cmdText As String = "INSERT INTO table(tbl_ID,tbl_Type,tbl_Type) VALUES (?,?,?)"
Dim cmd As SqlCommand = New OleDBCommand(cmdText, conn)

With cmd.Parameters
    .Add("@p1", OleDbType.Integer).Value = 0
    .Add("@p2", OleDbType.VarChar).Value = "my type"
    .Add("@p3", OleDbType.VarChar).Value = "my type"       
End With
cmd.ExecuteNonQuery()

edited Jul 29, 2013 at 7:42

answered Jul 29, 2013 at 7:19

matzone

5,7293 gold badges19 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

matzone Over a year ago

@RahulShirphule .. I just changed those 3 lines .. it's updated

matzone Over a year ago

@RahulShirphule .. it's changed .. for accessDB

Collectives™ on Stack Overflow

Insert query is not working access Vb.net

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related