Member Avatar for prixxershackit

how to INSERT FROM in vb.net if you are getting values from textboxes?

Edited by prixxershackit because: n/a
  • 3 Contributors
  • 2 Replies
  • 81 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for kingsonprisonic

Where u want to insert??

In database or what???

Member Avatar for M.Waqas Aslam

hello !
if you want to insert data from vb.net form to your mssql database then this code will help you

dim mycon as new sqlconnection("connectionstring")
mycon.open()
dim cmd as new sqlcommand
cmd.connection=mycon
cmd.commandtext="insert into table (field1,field2) values (@field1,@field2)"
cmd.parameters.addwithvalue("@field1",txtField1.text)
cmd.parameters.addwithvalue("@field2",txtField2.text)
cmd.executenonquery()
mycon.close()

Hope this will helps you :)
Regards

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.