sql - command timeout through SqlHelper in aps.net 2.0 -
i have application works asp.net 2.0, want increase command timeout using sqlhelper class;
dsdata = sqlhelper.executedataset(connectionstring, system.data.commandtype.storedprocedure, spname, m_sqlparam)
i can't find example on this, or should change sqlhelper code?
you can use sqlcommand.commandtimeout
property below
sqlcommand command = new sqlcommand(querystring, connection); command.commandtimeout = 20;
your sqlhelper
looks custom wrapper (or) repository class sqlcommand
. in such case, can either change code base in sqlhelper
class (or) have executedataset()
method accept argument timeout
Comments
Post a Comment