ds = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(), CommandType.Text, mystring, param);

now the strange thing is, when I run a netstat in the command prompt, I get quite a few connections to sql popping up in "TIME_WAIT"

any reason why this should be happening? or am I just thinking of functionality that isn't supposed to be there?

EDIT:

sorry, forgot to mention that the amount of connections increases as I carry on moving through pages.