Question

To execute a command object and store the results in a dataset, you use the Group of answer choices Fill method of a data adapter Select method of a data adapter ExecuteQuery method of a command ExecuteReader method of a command

Answer 1

Answer:

Fill method of a data adapter

Explanation:

This question is an illustration of C# Winforms and C# asp.net languages.

The following illustration works for all databases but let's assume we're dealing with MySql Database.

To store the results in a dataset, you have to

• Create a data table DataTable dt = new DataTable();
• Create a command (MySqlCommand cmd = new MySqlCommand(.......)
• Bridge the dataset and the database by using a data adapter MySqlDataAdapter msda = new MySqlDataAdapter(....)

• Lastly, fill the method of the data adapter using msda.Fill(dt)

Hence, (a) is correct