Dataset mit Stored Procedure füllen

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

/// <summary>
/// Get a DataSet from a stored procedure
/// </summary>
/// <param name="connectionString">the connectionstring</param>
/// <param name="storedProcedure">the name of the stored procedure</param>
/// <param name="tableName">the name of the DataTable in the Dataset</param>
/// <returns>the filled Dataset</returns>
private static DataSet GetDataSet(string connectionString, string storedProcedure, string tableName)
{
    DataSet ds = new DataSet();            
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand command = new SqlCommand(storedProcedure, connection);
    command.CommandType = CommandType.StoredProcedure;
    SqlDataAdapter SdmDataAdapter = new SqlDataAdapter(command);
    SdmDataAdapter.Fill(ds, tableName);
    return ds;
}