Can I get the SqlConnection from SqlDataAdapter?

Question

Is there any way to get the SqlConnection from an SqlDataAdapter?

I had expected to find an SqlDataAdapter.Connection property.

Answer 1

Look at the SelectCommand or whichever command you're interested in.

Answer 2

SqlDataAdapter has property SelectCommand (type of SqlCommand) and SelectCommand has property Connection (type of SqlConnection).