VS连接SQL server2012的数据访问层的一些数据处理

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
using ModaL;
namespace DaL
{
    public class UserDaL
    {
        //连接数据库
        public static string sdr = "Data Source=.;Initial Catalog=DATATABLES;Integrated Security=True";
        SqlConnection conn = new SqlConnection(sdr);
        /// <summary>
        /// 数据显示
        /// </summary>
        /// <returns></returns>
        public List<UserModaL> Show(int lenght,int start ,string name)
        {
            //打开数据库
            conn.Open();
            //建立桥接
            SqlDataAdapter dr = new SqlDataAdapter("select top " + lenght + " * from (select ROW_NUMBER() over (order by id) iid  ,u.* from DS u ) c  where iid>" + start,conn);
            //建立一个空的数据表
            DataTable dt = new DataTable();
            //将数据填充到空的数据表中
            dr.Fill(dt);
            //建立一个空的泛型集合
            List&l