netstat to check th SQL connection

[Agnes]

in form_load, i will new a sql connection ,fill in the dataset and then
close the connection.
I use Netstat to check the status.
(1)Open the form , The status to the SQL server is "ESTABILISHED"
(2)Close the form, The status is "TIME_WAIT"
(3)WAIT a sec. that thread is disappear .

my question is , I had closed the connection after fill in , WHY the status
still become "ESTABLISHED" ? ,
if the user open 10 forms, there will be 10 thread ???
Does anyone understand my stupid question ? thanks a lot

[Truong Hong Thi]

Hi Agnes,

my question is , I had closed the connection after fill in , WHY the status
still become "ESTABLISHED" ? When connection pooling is enable, and a connection is closed , it is
returned to the connection pool. if the user open 10 forms, there will be 10 thread ???

What did you mean by "thread"? If 10 forms of the same app opens
connection at the same time with same connection string, the pool will
supplies them with 10 connections. If connection is not available, the
request will be queued. There is one pool for each connection string.