title: update the database dataset without deleting it and creating a new one
body: <p>i'm developing a program on VB.net and it needs a database. My problem is that the client is all the time changing the structure of the database, adding some fields or changing the type of the data because after thinking a bit more he thinks is better.</p>
  
  <p>After the database change, i have to erase the dataset and recreate again, so all the code that needs it, or all the Datagrids makes error (sometimes all the for is deleted).</p>
  
  <p>Example code: (this creates a list of buttons)</p>
  
  <pre><code>Private Sub List_Products_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load       
  
      Me.ProductosTableAdapter.Fill(Me.Bbdd_DataSet.productos)
      Dim code As String 
      Dim contador As Integer = 0
  
      For i = 0 To Bbdd_DataSet.productos.Count - 1
          code = Bbdd_DataSet.productos(i).numero
  
          If InStr(code, "2") = 1 Then
              lst_prod.Items.Add(codigo)
              lst_precios.Items.Add(Bbdd_DataSet.productos(i).precio)
              btns = New System.Windows.Forms.Button
              btns.Left = 75
              btns.Width = 125
              btns.Height = 100
              btns.Font = New Drawing.Font("Times New Roman", 12, FontStyle.Regular)
              If code = 0 Then
                  btns.Top = botones.Height * contador
              Else
                 btns.Top = (botones.Height + 10) * contador
              End If
  
              btns.Text = Bbdd_DataSet.productos(i).nombre
              btns.Name = codigo
  
              AddHandler btns.Click, AddressOf add
              Controls.Add(btns)
              contador = contador + 1
          End If
      Next
  End Sub
  </code></pre>
  
  <p>On all the code that apear "Bbdd_DataSet" makes error becasue the DataSet have beed deleted.</p>
  
  <p>Is there any way to update the DataSet without deleting it and creating a new one? Becasue is a waste of time create the code again.</p>
  
  <p>Thanks all.</p>