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

        public static DataInfo GetDataKeyValue(string dataKeyName)
        {
            string _connStr = SetConn();

            DataInfo d = new DataInfo();

            SQLUpdateNugget n = SQLUpdateNugget.GetNuggets("SchemaVersionCheck").FirstOrDefault();
            if (n != null) {
                List<SqlParameter> parms = new List<SqlParameter>();

                SqlParameter parmKey = new SqlParameter();
                parmKey.ParameterName = "@DataKey";
                parmKey.SqlDbType = SqlDbType.VarChar;
                parmKey.Size = 100;
                parmKey.Direction = ParameterDirection.Input;
                parmKey.Value = dataKeyName;

                parms.Add(parmKey);

                DataTable dt = ExecuteDataTableCommands(_connStr, n.SQLQuery, parms);

                if (dt.Rows.Count > 0) {
                    DataRow dr = dt.Rows[0];

                    d.DataKey = dr["DataKey"].ToString();
                    d.DataValue = dr["DataValue"].ToString();
                }
            }

            if (d != null && String.IsNullOrEmpty(d.DataValue)) {
                d.DataValue = String.Empty;
            }

            return d;
        }