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

Popular posts from this blog

java - How to handle special characters while unmarshalling xml in JAXB -

ios - Pass NSDictionary from Javascript to Objective-c in JavascriptCore -

tensorflow when input_data MNIST_data , zlib.error: Error -3 while decompressing: invalid block type -