Resolved..... - Query timeout when using odbcDataAdapter

[manju]

Hi all,

In my asp.net application when I try to run my query using ODBCDataAdapter it throws the exception 'Query timeout expired'.
I am using dataadapter as I fill up the results into a dataset which is bound as datasource to my datagrid to display to user.

The same generates results when I use a OdbcDataReader.

Any reasons y this is happening??

Also does anyone have any idea on the number fo rows that can be displayed in a datagrid in a single page.
When I try to display the 50,000+ rows in a single page the ASP.Net wp.exe gets recycled.

P.S: The query returns more then 50,000 rows.


Any help will be appreciated.