I have a web page that loads data from a SQl server table.
Everytime the webpage loads it times out during the dataadapter.fill() function
This is what i tried.
1. Ran the same query in SQl server and it reurned the result set in 4 seconds.
2. Created a windows app with the same query and used a dataadapter to fill a dataset and diplay in grid. Worked in 5-6 seconds.
3. Increased the sqladapter.selectcommand.t
imout property to 0 and then the page never loads without any error displayed. only the non data part loads and the grid doent load.
This webpage worked fine when it was running on a webserver. But when i run it locally it timesout.
Public Function GetDataSet( s as String ) as DataSet
if not CheckSql() then exit Function
sqladapter = new SqlDataAdapter( sqlstr , conn )
ds = new DataSet()
sqladapter.Fill( ds , s )<<--- timeout
Return( ds )