connection time out error

Question

hi
i have created a procedure in database it contains the while loop. now i want to call that procedure using asp.net i have created a code but i does not work it gives an error of connection timeout. can somebody tells me what i need to do.