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

[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!

[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)