hi guys i have a stored procedure that basically has a select statement. i know my table is very big it could be well more than 1million rows. but the statement only runs for 2 mintues and already i get a time out. even though i set my timeout very high. here is the code for the function and the time out. please help me if you know what i did wrong. thank you very much
<httpRuntime executionTimeout="100000000" /> this is in the web.config
this below is in my default.aspx.vb .
query parameter is just a select like select * from table1.
Public Function GetDataTable(ByVal query As String) As DataTable
Dim adapter1 As New SqlDataAdapter
adapter1.SelectCommand = New SqlCommand(query, allfunctions.SQLConnection)
Dim table1 As New DataTable