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" );
      }
   }
}

<br />
SELECT @setting = UpdateSetting FROM Setting WHERE ID = @fieldid<br />
IF @setting = 1 OR (@setting = 2 AND IS NULL (SELECT field FROM Data WHERE id = @rowID)<br />
  UPDATE Data SET Field = @newfieldval WHERE ID = @rowID<br />

<br />
UPDATE Data SET field1 = @newField1Val, <br />
                field2 = @newField2Val,<br />
                [etc]<br />
                ...<br />
       WHERE id = @rowID<br />