public static void SetDataKeyValue(string dataKeyName, string dataKeyValue)
{
string _connStr = SetConn();
SQLUpdateNugget n = SQLUpdateNugget.GetNuggets("SchemaVersionUpdate").FirstOrDefault();
if (n != null) {
List<SqlParameter> parms = new List<SqlParameter>();
SqlParameter parmNewVal = new SqlParameter();
parmNewVal.ParameterName = "@DataValue";
parmNewVal.SqlDbType = SqlDbType.VarChar;
parmNewVal.Size = 100;
parmNewVal.Direction = ParameterDirection.Input;
parmNewVal.Value = dataKeyValue;
parms.Add(parmNewVal);
SqlParameter parmKey = new SqlParameter();
parmKey.ParameterName = "@DataKey";
parmKey.SqlDbType = SqlDbType.VarChar;
parmKey.Size = 100;
parmKey.Direction = ParameterDirection.Input;
parmKey.Value = dataKeyName;
parms.Add(parmKey);
ExecuteNonQueryCommands(_connStr, n.SQLQuery, parms);
}
}