// Updates a table called databaseTableName with columns // 'Key' and 'Value'. Its untested! public void UpdateSettingValueEntry( string databaseTableName, string key, string value) { private const string updateCommand = "UPDATE {0} SET Value = @value WHERE Key = '{1}'" using (SqlConnection databaseConnection = new SqlConnection(DatabaseConnectionString)) { try { databaseConnection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = databaseConnection; command.CommandText = string.format(updateCommand, databaseTableName, key); command.Parameters.AddWithValue("@value", value); Debug.Trace("SQL({0})", command.CommandText); int rows = command.ExecuteNonQuery(); if (rows == 1) { Debug.WriteLine("Updated key \'" + key + "\' to value of \'" + value + "\'"); } else { HandleError("Updated key \'" + key + "\' to value of \'" + value + "\' returned unexpected row count of \'" + rows + "\'"); } if (rows < 1) { HandleUpdateError(xxx); } } } catch (SqlException se) { HandleException(se); } } }
November 13, 2007
C# SQL Update Key Value Type Table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment