Member Avatar for zarifin99ska

is this possible?

Dim wa As Integer = 1
            con = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Bengkel\Project\db.mdb")
            con.Open()

           
            myCommand = New OleDbCommand("insert into payment  (slip) VALUES (wa) ", con)        'insert the value of "wa"

            myCommand.ExecuteNonQuery()
            wa = wa + 1

if i'm wrong, can someone help me?

  • 2 Contributors
  • 1 Reply
  • 110 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by lolafuertes
Member Avatar for lolafuertes

I prefer to write:

myCommand = New OleDbCommand("insert into payment  (slip) VALUES (" & wa.tostring & ") ", con)        'insert the value of "wa"

Hope this helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.