Carrotware.CMS.DBUpdater.DatabaseUpdate.SetDataKeyValue C# (CSharp) Method

SetDataKeyValue() public static method

public static SetDataKeyValue ( string dataKeyName, string dataKeyValue ) : void
dataKeyName string
dataKeyValue string
return void
        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);
            }
        }