Member Avatar for q8_dreamy

hi
i have textbox and i want to insert this text into access db but the field in db is number so i tried both functions val and cint to convert text to integer while iam inserting at the same time but i got error : Input string was not in correct format!

this is my code:

cmcontact.CommandText = "insert into table1_local(id) values" + (Val(Me.TextBox1.Text)) + ";"

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man

why you don't make user to do not input string/char inputs? make them to input numbers only. so you don't have to convert input from text to number.

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.