Database

public partial class Form1:Form
{
   private BindingSource BindingSource1 = new BindingSource();
   SqlDataAdapter dataAdapterFinca = null;
   DataSet dataSetFinca = null;

   public Form1()
   {
      InitializeComponent();
      this.Load += new System.EventHandler(Form1_Load);
   }

   protected void Form1_Load(object sender,System.EventArgs e)
   {
      dataGridView1.DataSource = BindingSource1;

      GetData();
   }

   protected void GetData()
   {
      SqlConnection connection = new SqlConnection("MyConnectionString");

      dataSetFinca = new DataSet();
      dataSetFinca.Locale = System.Globalization.CultureInfo.InvariantCulture;

      dataAdapterFinca = new SqlDataAdapter("select * from Finca",connection);
      dataAdapterFinca.Fill(dataSetFinca,"Finca");

      BindingSource1.DataSource = dataSetFinca;
      BindingSource1.DataMember = "Finca";

   }

   private void button1_Click(object sender,EventArgs e)
   {
      if( dataSetFinca.HasChanges() )
      {
         // The debugger comes in here if I've changed anything in the grid
         // I am flailing wildly here trying to hit on something that will force the data out of the dataset and back to the SQL
         this.Validate();
         this.BindingSource1.EndEdit();
         this.Update();
         dataSetFinca.AcceptChanges();
         dataAdapterFinca.Update( dataSetFinca, "Finca" );
      }
   }
}