FillIntoExistingDataSetAsync Method

Overview

The FillIntoExistingDataSetAsync method asynchronously executes one or more queries and adds the returned tables into an existing POCO IDataSet.

Declarations

/// <summary>
/// Fills an existing data set by adding one or more result-set tables into it.
/// </summary>
public async Task<IDataSet> FillIntoExistingDataSetAsync(IDataSet dataSet, string baseQuery, bool isStoredProcedure, Dictionary<string, object?>? parameters, List<string>? returnedTableNames, string? connectionString)

/// <summary>
/// Fills an existing data set by adding one or more result-set tables into it using provider-specific SQL parameters.
/// </summary>
public async Task<IDataSet> FillIntoExistingDataSetAsync(IDataSet dataSet, string baseQuery, bool isStoredProcedure, params SqlParameter[] parameters)

/// <summary>
/// Fills an existing data set by adding one or more result-set tables into it using provider-specific SQL parameters.
/// </summary>
public async Task<IDataSet> FillIntoExistingDataSetAsync(IDataSet dataSet, string baseQuery, bool isStoredProcedure, SqlParameter[]? parameters, List<string>? returnedTableNames, string? connectionString)

/// <summary>
/// Fills an existing data set by adding one or more result-set tables into it using table-valued parameter descriptions.
/// </summary>
public async Task<IDataSet> FillIntoExistingDataSetAsync(IDataSet dataSet, string baseQuery, bool isStoredProcedure, SqlTableValuedParameterInfo[]? tableValuedParameters, List<string>? returnedTableNames, string? connectionString)

Namespace and Assembly

Namespace: PocoDataSet.SqlServerDataAdapter
Assembly: PocoDataSet.SqlServerDataAdapter.dll

Usage Example

IDataSet dataSet = DataSetFactory.CreateDataSet();
SqlDataAdapter adapter = new SqlDataAdapter(connectionString);

await adapter.FillIntoExistingDataSetAsync(dataSet, "SELECT * FROM Department", false, (Dictionary<string, object?>?)null, null, null).ConfigureAwait(false);

await adapter.FillIntoExistingDataSetAsync(dataSet, "SELECT * FROM Employee", false, (Dictionary<string, object?>?)null, null, null).ConfigureAwait(false);

IDataTable departmentTable = dataSet.Tables["Department"];
IDataTable employeeTable = dataSet.Tables["Employee"];

 

Table of Content POCO DataSet API References SqlDataAdapter Members

 

---

Business Process Programming in .Net
© 2004–2026 Laskarzhevsky Software Inc.
Unless otherwise noted, the content of this website is licensed under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
Code examples are provided under the MIT License.
You are free to share and adapt the material provided that appropriate credit is given and any modifications are clearly indicated.
The information provided on this website is for educational purposes only.
The author and publisher make no warranties regarding the completeness or suitability of the information and are not responsible for any damages resulting from its use.