Hello, thank you in advance for any help. I have searched the forms for the past couple days and haven't been able to find a solution to my problem. I am attempting to do an update statement, but it will always time out. I have tried running the update statement
directly on the server and it works fine, but when I run it through my C# program it times out.
Below is the code I use for the update statement. Again any help would really be appreciated.
List<string> statements = new List<string>();
statements.Add("UPDATE ticket SET ");
statements.Add("priority=@NewPriority, ");
statements.Add("resolved=@NewResolved, ");
statements.Add("hwProblems=@NewHwProblems, ");
statements.Add("swProblems=@NewSwProblems, ");
statements.Add("closeDate=@NewCloseDate, ...
Go to the complete details ...