dataGridView.VirtualMode = true;
dataGridView.CellValueNeeded += new DataGridViewCellValueEventHandler(OnCellValueNeeded);

 void OnCellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
        {
            int count = (sender as DataGridView).RowCount;
            if (e.RowIndex >= count) return;
            if (e.RowIndex < indexOffset || e.RowIndex >= indexOffset + dataTable.Rows.Count)
            {
                dataTable.Clear();
                indexOffset = Math.Max( 0 , e.RowIndex -  300 );
                
                string query = string.Format("SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY id) AS num, * FROM {0} ) t WHERE num BETWEEN {1} AND {2} ORDER BY num", "Journal", indexOffset, Math.Min(count, e.RowIndex +  300 ));
                sqlCommand = new SqlCommand(query, sqlConnection);
                dataTable.BeginLoadData();
                var sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                sqlDataAdapter.Fill(dataTable);
                dataTable.EndLoadData();
            }
            object val = dataTable.Rows[e.RowIndex - indexOffset][e.ColumnIndex];
            e.Value = val;
        }