ASP.NET connections to SQL server
<p>this isnt technical question on how to connect to SQL server i know how to connect to SQL server using connected and disconnected mode, but iam a Little confused on how many connection is created when multiple users is requesting data it seem all the user requesting the page use the same connection because if the connection was open and error happen all the users have error when open connection saying the connection is already open, what i need to know is how the connection work when multiple user is connected to my website, questions to be more clear on:-</p>

<p>1-why if one connection didnt get closed all the users who suppose to have diffident connection suffer same error?</p>

<p>2- if its only one connection used to the whole website that mean if user open connection he have to close it first before another user can use the connection even if use query take 30 minute?</p>

<p>thank you in advance,</p>
