please where the problem is please

[seshu]

hi every body this is seshu
here in the following snipet i am able to see the success msg
but i dont know why that row is not getting inserted in mysql table
Imports System.Data.Odbc
Imports System.Data.Common.DbCommand
Public Class Form1


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim constr As String
constr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=seshu;UID=root;P WD=seshu"
Dim con As New OdbcConnection(constr)
Dim da As New OdbcDataAdapter("select*from emplogin", con)
da.InsertCommand = New OdbcCommand("insert into emplogin values('sesh019','venkatesh','venkatesa','venkipin ki',null)", con)
Dim ds As New DataSet
'Dim builder As CommandBehavior = CommandBehavior.SingleRow
con.Open()
da.Fill(ds)
da.Update(ds)
con.Close()
MsgBox("success")
'Dim builder As OdbcC
'Dim cmd As New OdbcCommand("insert into emplogin values()")
'("DRIVER={SQL Server};SERVER=MyServer;Trusted_connection=yes;DAT ABASE=northwind;")

End Sub
please show me the mistake in detail please

[bplacker]

Dim da As New OdbcDataAdapter("select*from emplogin", con)
da.InsertCommand = New OdbcCommand("insert into emplogin values('sesh019','venkatesh','venkatesa','venkipin ki',null)", con)
Dim ds As New DataSet
'Dim builder As CommandBehavior = CommandBehavior.SingleRow
con.Open()
da.Fill(ds)
da.Update(ds)



the line da.Update(ds) updates the dataset with what is in the dataadapter, it doesnt update the dataadapter, nor the database.

the line you want is...

da.InsertCommand.Connection = con
da.insertCommand.ExecuteNonQuery();