troubleshooting Question
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
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.