The connection expires during myAdapter.Fill(myDataSet, "TestTable")
myAdapter = New SqlDataAdapter(sqlString, myConn)
myDataSet = New DataSet
I have seen lot of examples on the net for myCmd.CommandTimeout = 300, but that works only with sqlReader not with DataSet.
How Can I fix timeout error? I know my query works. It takes close to 1 minute to run on sql server. Meanwhile asp application is throwing an error.