I have a table with over 1.3 million rows. I am retrieving only 20 at a time
using the with - over clauses
In query analyser, the data is retrieved in under a second.
When retrieving using the data adaptor.fill or datareader to retrieve the

I have read several resources on the internet and MSFT newsgroups on how to
insert data using the footer in the datagrid control.
To solve the empty data set problem, I added a blank row in the datasource
select statement, using the union command to create the additional blank row ...

I have a datagrid with boudcolums and templatecolumns. The
templatecolums have a ItemTemplate that contains controls.
I would like to iterate through these controls. I cannot use the
FindControl method because I dont know the ID of the controls. I don't

I'm rather confused / frustrated with paging. It seems impossible.
I have a database with X rows in a table, and I want to present a grid that
shows a paged view of just 10 items, and let the user navigate through he
entire table 10 items at a time. Simple enough, right?

I am using this code that I have found in the internet to generate excel
output.
       Response.Clear();
       Response.AddHeader("content-disposition",

I have a gridview "new" command that insert a new row into a postgresql
database.that uses the odbc driver.
Newbie as I am i thought that iReturn would have the new index that was
created.

I have a Web Part that contains a relatively simple DataGrid, paginated
across four pages. Switching between pages 2, 3 and 4 works fine, but if you
request the first (0th) page again, the PageIndexChanged event does not fire.
Please see my code below: