troubleshooting Question 2008 update dataset to MySql

Avatar of aarontham
aarontham asked on
.NET ProgrammingMicrosoft DevelopmentVisual Basic.NET
3 Comments1 Solution598 ViewsLast Modified:
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()
            Catch exError As Exception
                MessageBox.Show(exError.Message, _
                Me.Text, _
                MessageBoxButtons.OK, _
                Exit Sub
            End Try
            Me.DataGridView1.DataSource = myDataSet
        End Using

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros