Archief - C#: DataGridView paging dmv scrollen

            SqlConnection conn = clsCommonFunctions.cInstance.connection;

            SqlCommand command = new SqlCommand(
            "SELECT c.vc50_Title, c.vc50_LastName, c.vc50_FirstName, l.vc10_Code, g.vc10_Code, a.vc255_Street1, c.vc255_Remarks " +
            "FROM tbl_Contact c, tbl_Language l, tbl_Gender g, tbl_Address a " +
            "WHERE l.num_Id = c.num_LanguageId " +
            "AND c.num_GenderId = g.num_Id " +
            "AND c.num_AddressId = a.num_Id " +
            "LIMIT " + uloCurrentSetBottom.ToString() + "," + intRange.ToString()
            , conn);


            SqlDataReader reader = command.ExecuteReader();

            int i = 0;

            //Voorbeeld voor unbound dgv, vullen met do while?
            while (reader.Read())
            {
                dgvContacts.Rows[i].Cells[0].Value = reader[0];
                dgvContacts.Rows[i].Cells[1].Value = reader[1];
                dgvContacts.Rows[i].Cells[2].Value = reader[2];
                dgvContacts.Rows[i].Cells[3].Value = reader[3];
                dgvContacts.Rows[i].Cells[4].Value = reader[4];
                dgvContacts.Rows[i].Cells[5].Value = reader[5];
                dgvContacts.Rows[i].Cells[6].Value = reader[6];
                i++;
            }

            reader.Close();
            conn.Dispose();

var query = from c in db.Category
		from p in db.Product
                where p.CategoryID == c.CategoryID && 
                         p.UnitsInStock < 2
		select new 	{ c.CategoryName, p.ProductName };

SELECT TOP (20)
	[c].[CategoryName],
	[t1].[ProductName]
FROM
	[Categories] [c], [Products] [t1]
WHERE
	[t1].[CategoryID] = [c].[CategoryID] AND [t1].[UnitsInStock] < 2

SELECT *
FROM
(
	SELECT
		t.*,
		ROW_NUMBER() OVER
		(
			ORDER BY
				t.[CategoryName],
				t.[ProductName]
		) as rn
	FROM
	(
		SELECT
			[c].[CategoryName],
			[t1].[ProductName]
		FROM
			[Categories] [c], [Products] [t1]
		WHERE
			[t1].[CategoryID] = [c].[CategoryID] AND [t1].[UnitsInStock] < 2
	) t
) t2
WHERE
	t2.rn BETWEEN 21 AND 40