Datagrid

Hi all,


I have a data grid which is being displayed on my web page. The datagrid is generated by a stored procedure like the one below.

The first and last rows are dummy rows and I need to Permanently show or hide these rows depending on the number or rows returned in between.

i.e. if row 2 passes a condtion then I want to hide row one once the screen loads.

Does anyone know if there is a way this can be done.

I'm using a Query with UNION in it like the this one below.
Is it possible to remove the first and last rows in the Query if a certain condtion passed or can this be done in in the vb.net code when I'm binding the datagrid

SELECT Bookname, 1 AS VERSION, COUNT(*) OVER () AS totalRows
FROM book
WHERE bookname = 'doctor Who'
UNION
SELECT Bookname, VERSION, COUNT(*) OVER () AS totalRows
FROM tablebook
WHERE bookname = 'Harry potter'
UNION
SELECT Bookname, 20 AS VERSION, COUNT(*) OVER () AS totalRows
FROM book
WHERE bookname = 'Witches and wizards'

Results

BookName VERSION totalRows
Doctor Who 1 1
Harry potter 3 1
Harry potter 3 2
Harry potter 3 3
Witches AND wizards 1 20