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.

try

DS = New DataSet

Comm.CommandTimeout = 10

DA = New SqlDataAdapter(Comm)

DA.Fill(DS)

 catch ex as sqlexception

     'code that writes to log table

 end catch



Thanks.