I was just wondering why an instance of a connection object is needed when creating a new instance of a command object
Code:
objCommand = New sqlClient.SqlCommand(strSQL, New SqlClient.SqlConnection(strConn))
but one is not need when used as a parameter to a data adapter
object.

Code:
objDA = New SqlClient.SqlDataAdapter(strSql, strConn)
objDA.fill(objDS)