DataAdapters aren't ever "open" so closing them is meaningless. The connection is an independent object so it has no effect on the adapter in that regard. The adapter doesn't know, or care, whether a connection is open or closed until it tries to use it.