dataadapter/command/dataset sql timeout
I want to replicate sql timeout error. i have a stored procedure and it returns few tables (more than 3 select statement).
inorder to replicate sql timeout, in the following statements i set commandtimeout to 10 secs and it doesnt throw timeout error eventhough it takes more than couple of minutes to execut DA.Fill(DS) but i actually locked some tables that are used by this stored procedure. Can someone please suggest a way to replicate timeout in this dataadapter fill code? or how to set timeout settings for dataadapter.
DS = New DataSet
Comm.CommandTimeout = 10
DA = New SqlDataAdapter(Comm)
catch ex as sqlexception
'code that writes to log table