public DataSet PagingProducts(DataSet ds,int page,int pagesize)
    {
        int end, start;
        DataSet ds2 = new DataSet();
        DataTable dt = new DataTable("mydt");
        
        for(int i=0;i<ds.Tables[0].Columns.Count;i++)
        {
            dt.Columns.Add(ds.Tables[0].Columns[i]);
        }
        ds2.Tables.Add(dt);
        if (page != pagesize)
        {
            end = page * 10;
            start = end - 9;
        }
        else
        {
            end = int.Parse(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1][0].ToString());
            start = end - 9;
        }
        for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
        {
            for (int i = start; i <= end; i++)
            {
                ds2.Tables[0].Rows[i][j] = ds.Tables[0].Rows[i][j];
            }
        }
        return ds2;
    }

public DataSet PagingProducts(DataSet ds,int page,int pagesize)
    {
        int end, start;
        DataSet ds2 = new DataSet();
        DataTable dt = new DataTable("mydt");
        
        for(int i=0;i<ds.Tables[0].Columns.Count;i++)
        {
            dt.Columns.Add(ds.Tables[0].Columns[i].ColumnName);
        }
        
        if (page != pagesize)
        {
            end = page * 10;
            start = end - 9;
        }
        else
        {
            end = int.Parse(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1][0].ToString());
            start = end - 9;
        }
        for (int i = start; i <= end; i++)
        {
        dt.Rows.Add(ds.Tables[0].Rows[i]);
                
        }
        ds2.Tables.Add(dt);
        return ds2;
    }