Below is the page that I created in VS2005. I am new to doing things programatically in ASP.Net and so far have gotten everywhere I wanted to go by using the drop in widgets in VS. Now I am faced with a page that gives me a timeout error when updating to a SQL server. The query itself is fairly simple, a stored procedure updates two tables on two differrent servers. The problem is because of distance and other factors it sometimes takes longer than the allowed 30 seconds.
I have seen information that setting the timeout for the sqlcommand can be done, but I am having trouble putting into the context of this project and getting my head around it. Could someone help me understand how to put it all together?