Page 1 of 1

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

Posted: Tue 08 Feb 2005 21:43
by Blacksmith
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:

Posted: Wed 09 Feb 2005 10:47
by Serious
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)