my code below fails because sql execution time is more than default time (30sec). Can I add code for sql to take more time for execution? it works fine if execution time is less. I want to give more time for stored procedure to run so I can display all data it pulls. Thanks in advance for any advice.
var dr = ExecuteRows("exec [dbo].[GetStaffDoc] '" + param1 + "', '"+ param2+"'", "DB");