SqlDataAdapter与SqlCommand

SqlCommand mycom = new SqlCommand("dgPro_PagesApartFind", conn);
            mycom.CommandType = CommandType.StoredProcedure;

            mycom.Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int)).Value = pagesize;
            mycom.Parameters.Add(new SqlParameter("@CurentPage", SqlDbType.Int)).Value = curpage;
            mycom.Parameters.Add(new SqlParameter("@SelSql", SqlDbType.NVarChar)).Value = sql;
            mycom.Parameters.Add(new SqlParameter("@SortBy", SqlDbType.VarChar)).Value =sortby;
            mycom.Parameters.Add(new SqlParameter("@sortID", SqlDbType.VarChar)).Value =sortid;

            SqlDataAdapter da = new SqlDataAdapter(mycom);
            DataSet ds = new DataSet();
            da.Fill(ds);