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!
Insert into TABLE from textbox1, 2, 3, 4 by click of a button instead of datagrid
You can manually create SQL queryor use parameters
Code: Select all
insert into `dept` (`deptno`,`dname`,`dloc`) values (100,'dept1','loc1')
Code: Select all
insert into `dept` (`deptno`,`dname`,`dloc`) values (:p1,:p2,:p3)