C# - Issue with update statements to SQL Server

Hi everyone,

I am in the process of testing update statements to SQL using C#.
I am finding that the update statements pass, but the db doesn't get updated.

Am I missing a commit (or something similar) ?

Here is what I have so far:

try
{
      SqlCeCommand updateKeyCommand = new SqlCeCommand("UPDATE testtable SET Test_Col_1 = '" + resultingString + "' WHERE Test_Col_1 = '" + replaceKeyCommand_dr.GetString(0) + "'", conn);
      
      updateKeyCommand.CommandType = CommandType.Text;
      updateKeyCommand.ExecuteNonQuery();

      MessageBox.Show("Successful...");
}
catch (Exception ex)
{
      MessageBox.Show(ex.Message);
}

No errors are being thrown, but the db doesn't get updated according to what I'm seeing.
Can anyone shed some light as to what I'm missing?

Tags: C#, SQL Server CE, SQL Server, Visual Studio 2012, Forms