How Can I Directly Populate a DataSet from a SQL Command?

Direct Route to Populate a DataSet from SQL Command Text

Question:
How can I efficiently obtain a DataSet by directly executing a SQL command?

Introduction:
Working with relational data often involves retrieving data from a database using SQL queries. To efficiently populate a DataSet with the results of a SQL command, there are various approaches available.

Direct Method Using SqlDataAdapter:
The most direct method to get a DataSet from a SQL command is to use a SqlDataAdapter. The code snippet below provides a direct implementation:

public DataSet GetDataSet(string ConnectionString, string SQL)
{
    // Create a SQL connection
    SqlConnection conn = new SqlConnection(ConnectionString);
    
    // Create a data adapter to bridge SQL command to DataSet
    SqlDataAdapter da = new SqlDataAdapter();
    
    // Create a SQL command to execute
    SqlCommand cmd = conn.CreateCommand();
    cmd.CommandText = SQL;
    da.SelectCommand = cmd;
    
    // Create a DataSet to hold the data
    DataSet ds = new DataSet();
    
    // Fill the DataSet with data
    da.Fill(ds);
    
    // Return the DataSet
    return ds;
}

Explanation:

• The GetDataSet() method accepts a connection string and SQL command text as parameters.
• A SqlConnection is created using the provided connection string to establish a connection to the database.
• A SqlDataAdapter is then created, which acts as a bridge between the SQL command and the DataSet.
• A SqlCommand is created, configured with the SQL command text, and assigned to the data adapter's SelectCommand property.
• A new DataSet is created to store the data retrieved from the database.
• The Fill() method of the data adapter is invoked to populate the DataSet with the data from the executed SQL command.
• Finally, the populated DataSet is returned as the result.

The above is the detailed content of How Can I Directly Populate a DataSet from a SQL Command?. For more information, please follow other related articles on the PHP Chinese website!