BVNetwork.NotFound.Core.Data.DataAccessBaseEx.GetRequestReferers C# (CSharp) Method

GetRequestReferers() public method

public GetRequestReferers ( string url ) : DataSet
url string
return System.Data.DataSet
        public DataSet GetRequestReferers(string url)
        {
            string sqlCommand = string.Format("SELECT [Referer], COUNT(*) as Requests FROM {0} where [OldUrl] = @oldurl  GROUP BY [Referer] order by Requests desc", REDIRECTSTABLE);
            var oldUrlParam = this.CreateParameter("oldurl", DbType.String, 4000);
            oldUrlParam.Value = url;

            var parameters = new List<IDbDataParameter>();
            parameters.Add(oldUrlParam);
            return ExecuteSQL(sqlCommand, parameters);
        }