Insert into TABLE from textbox1, 2, 3, 4 by click of a button instead of datagrid

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Blacksmith

Insert into TABLE from textbox1, 2, 3, 4 by click of a button instead of datagrid

Post by Blacksmith » Tue 08 Feb 2005 21:43

can anyone show me how to do this?
vb.net new form ...add the connection...its open
the form has several textbox(s) that the data is taken from to send to the mysql database (4.1) with a simple click of a button.
thanks in advance! :roll:

Serious

Post by Serious » Wed 09 Feb 2005 10:47

You can manually create SQL query

Code: Select all

insert into `dept` (`deptno`,`dname`,`dloc`) values (100,'dept1','loc1')
or use parameters

Code: Select all

insert into `dept` (`deptno`,`dname`,`dloc`) values (:p1,:p2,:p3)

Post Reply