[转帖]DataGrid的自定义分页UserControl

[转帖]DataGrid的自定义分页UserControl(13)         {
            using(SqlConnection conn = new SqlConnection("User id=sa;passWord=admin;server=server-mk;initial catalog=pubs;timeout=90")
            {
                SqlCommand cmd = new SqlCommand(proc,conn);
cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@CurrentPage",currentpage);
                cmd.Parameters.Add("@PageSize",pagesize);
                cmd.Connection.Open();

                SqlDataReader sdr = cmd.ExecuteReader();