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

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

Postby 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:
Blacksmith
 

Postby 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)
Serious
 


Return to dotConnect for MySQL