title: MySQL .NET using DataSet
body: <pre><code>Dim update_status = False
  
  Dim tableName = "SF6SETUP"
  
  Dim conn As MySqlConnection = New MySqlConnection(cs)
  Dim da As MySqlDataAdapter = New MySqlDataAdapter()
  'Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM SF6SETUP")
  Dim ds As DataSet = New DataSet()
  
  ' Open connection as late as possible to get data.
  conn.Open()
  da.SelectCommand = New MySqlCommand("SELECT * FROM SF6SETUP")
  da.SelectCommand.Connection = conn
  
  da.Fill(ds)
  
  ' Make a change to some row then update it.
  ds.Tables(0).Rows(0).Item("O2AreaCts") = "73333337"
  ds.AcceptChanges()
  
  da.Update(ds)
  
  conn.Close()
  </code></pre>
  
  <p>Can someone please help me figure out what am I doing wrong. I get no error. No changes made in the table.</p>
  
  <p>Why ?!!!</p>