troubleshooting Question

VB.net 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()
 
            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
ASKER CERTIFIED SOLUTION
amar31282

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