asked on 3/14/2009

VB.net 2008 update dataset to MySql

i populate an datagridview with below code. then user will do some edit on the datagridview . after the edit i need an button to update back the data to MySql. pls provide code.

Dim cnString3 As String = My.Settings.DataCon
        Dim strQuery3 As String = "SELECT * From t_user"
 
        Using adapter As New MySqlDataAdapter(strQuery3, cnString3)
 
            Dim myDataSet As New DataTable()
 
            Try
                adapter.Fill(myDataSet)
            Catch exError As Exception
 
                MessageBox.Show(exError.Message, _
                Me.Text, _
                MessageBoxButtons.OK, _
                MessageBoxIcon.Error)
                Exit Sub
            End Try
 
              'FILL DATAGRIBVIEW FROM DATABASE
            Me.DataGridView1.DataSource = myDataSet
 
        End Using

Open in new window

.NET Programming Microsoft Development Visual Basic.NET

Last Comment

amar31282

3/15/2009

amar31282

3/14/2009

Try this One to update data

Dim cnString3 As String = My.Settings.DataCon
        Dim strQuery3 As String = "Update table t_user set column1=@column1value, column2=@column2value..... where condition"
 
	Dim cmd As New OleDbCommand()
        
        cmd.Parameters.Add("@column1valuer", OleDbType.VarChar).Value = DatagridColumn1.Text
        cmd.Parameters.Add("@column2value", OleDbType.VarChar).Value = DatagridColumn1.Text
 
 
            Try
            cmd.CommandText = strQuery3 
            cmd.Connection = objConnection;
            cmd.ExecuteNonQuery();
 
            Catch exError As Exception
 
                MessageBox.Show(exError.Message, _
                Me.Text, _
                MessageBoxButtons.OK, _
                MessageBoxIcon.Error)
                Exit Sub
            End Try

Open in new window

aarontham

3/15/2009

ASKER

i prefer to use adaptor.Update. but i can't get it work. Pls provide code which use button to fire the save event.

ASKER CERTIFIED SOLUTION

amar31282

3/15/2009

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial