What actions should you take?

You are employed as a developer at ABC.com.
ABC.com makes use of SQL Server in their environment.
You have created a new application for ABC.com that contains a SqlDataAdapter object. The
SqlDataAdapter object has been linked to a table. You are planning to make use of the Fill method
for returning information from the table.
You have been informed that the Fill method should access the SQL server database connection,
read the data, and leave a closed connection.
What actions should you take? (Choose all hat apply.)

A.
You should consider setting the Connection property of the SqlDataAdapter object to an
applicable SQL Server database connection.

B.
You should consider setting the Connection property of the SqlDataAdapter object to an
applicable data table.

C.
You should consider configuring the SQL Server database connection to be in a closed state.

D.
You should consider configuring the SQL Server database connection to be in an open state.