C#.NET万能数据库访问封装类(ACCESS、SQLServer、Oracle) private IDbConnection GetConnection() { switch(this.DbType) { case "SqlServer": return new System.Data.SqlClient.SqlConnection(this.ConntionString); case "Oracle": return new System.Data.OracleClient.OracleC
看过此博文后Oracle、MySql、SQLServer 数据分页查询，在根据公司的RegionRes表格做出了
SQLserver的分页查询语句：
SELECT DISTINCT TOP 500
rr.ID AS id
，rr.strName AS name
，rr.nType AS res_type
，rr.nRegID AS region_id
，rr.strChanName AS channel_name
，rr.nChanNum AS channel
，rr.nS
