how to insert data into mysql through vb.net

[seshu]

hi everybody
this is seshu i am creating an application for chekin/checkouttime
for that i need to insert data in to mysql for that i know the command in mysql and even how to do in vb.net but the problem is i dont know how to command in vb and update that to mysql
see i was stuck here

Imports System.Data.Odbc
        Dim con As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=mydb;UID=root;PWD=mydb:OPTION=03")
        Dim da As New OdbcDataAdapter
        da.SelectCommand = New OdbcCommand("insert into emplogin values('MTI019','venkatesh','venkatesa','venkipinki',null)", con)
        Dim ds As New DataSet
        Dim builder As CommandBehavior = CommandBehavior.SingleRow
        con.Open()
 
'The Following Line Was Bolded
        Dim builder As OdbcCommand builder
        'Dim cmd As New OdbcCommand("insert into emplogin values()")
da.Fill(ds, "emplogin")
        da.Update(ds, "emplogin")

iam not finding that in vs2005
i mean the command in bold

[seshu]

please help me there

[siricharan82]

Imports System.Data.Odbc
        Dim con As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=mydb;UID=root;PWD=mydb:OPTION=03")
        Dim da As New OdbcDataAdapter
        da.insertCommand = New OdbcCommand("insert into emplogin(field1,field2,field3,field4,field5) values('MTI019','venkatesh','venkatesa','venkipinki',null)", con)
              Dim builder As new OdbcCommand builder(da)
        da.Update(ds, "emplogin")

**********

to select the values from table

da.selectcommand=new odbccommand("select * from emplogin",con)
Dim ds As New DataSet
da.fill(ds)

[outsider5486]

if i want to insert the data by using ODBC through vb.net, how can i do this?i want insert the data from the textbox that i provided..mean that the data with insert to the textbox then can store in the database with is QSL server..thanksss...need help!!!!

[blackshadow29]

this is an easy code to connect to a SQL database to insert data....

import system.data.odbc
import system.configuration  //must be added by add refference
import system.net
import system.text
 
 
dim con as new OdbcConnection
dim cmd as new OdbcCommand
dim da as new OdbcDataAdapter
 
con.connectionstring = getconnection()  //getconnection is an addional method
cmd.connection = con
con.open()
cmd.commandtype = cmd.commandtext
cmd.commandtype = "Insert Into TableName (...,...,...) VALUES ("' + ... + "','" + ... + "','" + ... + "')"
 
da.InsertCommand = cmd
 
cmd.ExecuteNonQuery()
con.Close()
con.Dispose()
cmd.Dispose()

[Frinavale]

If you are inserting data into your database you need to supply something for the values you are inserting.

The best way to do this in .NET is to use parameters. The OdbcCommand Object has a Parameters property for this purpose.


Please take a look at the article on how to use a database in your program and since you are using ODBC you should check out how to use a database in your program part II.