Avatar of aarontham
aarontham

asked on 

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 ProgrammingMicrosoft DevelopmentVisual Basic.NET

Avatar of undefined
Last Comment
amar31282
Avatar of amar31282
amar31282
Flag of India image

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

Avatar of aarontham
aarontham

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
Avatar of amar31282
amar31282
Flag of India image

Blurred text
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
.NET Programming
.NET Programming

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo