DataSet Constructors

Reference

Definition

Namespace:: System.Data

Assembly:: System.Data.Common.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Initializes a new instance of the DataSet class.

Overloads

DataSet()	Initializes a new instance of the DataSet class.
DataSet(String)	Initializes a new instance of the DataSet class with the given name.
DataSet(SerializationInfo, StreamingContext)	Obsolete. Initializes a new instance of the DataSet class with serialized data.
DataSet(SerializationInfo, StreamingContext, Boolean)	Obsolete. Initializes a new instance of the DataSet class with serialized data.

DataSet()

Source:: DataSet.cs

Source:: DataSet.cs

Source:: DataSet.cs

Initializes a new instance of the DataSet class.

public:
 DataSet();

public DataSet ();

Public Sub New ()

Examples

The following example creates a new DataSet, and adds two DataTable objects to it.

Private Sub CreateDataSet()
    Dim dataSet As New DataSet()

    ' Create two DataTable objects using a function.
    Dim table1 As DataTable = MakeTable("idTable1", "thing1")
    Dim table2 As DataTable = MakeTable("idTable2", "thing2")
    dataSet.Tables.Add(table1)
    dataSet.Tables.Add(table2)
    Console.WriteLine(dataSet.Tables.Count)
End Sub
 
 
Private Function MakeTable(c1Name As String, _
    c2Name As String) As DataTable
    Dim table As New DataTable
    
    ' Add two DataColumns
    Dim column As New DataColumn( _
        c1Name, System.Type.GetType("System.Integer"))
    table.Columns.Add(column)
    column = New DataColumn(c2Name, _
        System.Type.GetType("System.String"))
    MakeTable = table
End Function

Remarks

This implementation of the DataSet constructor takes no parameters, and creates a default name, "NewDataSet," for the new instance.

A name for the DataSet is required to ensure that the XML representation of the DataSet always has a name for the document element, which is the highest-level element in a schema definition.

Applies to

.NET 9 ja muud versioonid

Toode	Versioonid
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

DataSet(String)

Source:: DataSet.cs

Source:: DataSet.cs

Source:: DataSet.cs

Initializes a new instance of the DataSet class with the given name.

public:
 DataSet(System::String ^ dataSetName);

public DataSet (string dataSetName);

new System.Data.DataSet : string -> System.Data.DataSet

Public Sub New (dataSetName As String)

Parameters

dataSetName: String

The name of the DataSet.

Examples

The following example creates a new DataSet, to which two DataTable objects are added.

Private Sub CreateDataSet()
    Dim  dataSet As New DataSet("aNewDataSet")

    ' Create two DataTable objects using a function.
    Dim table1 As DataTable = MakeTable("idTable1", "thing1")
    Dim table2 As DataTable = MakeTable("idTable2", "thing2")

    dataSet.Tables.Add(table1)
    dataSet.Tables.Add(table2)
    Console.WriteLine(dataSet.DataSetName, dataSet.Tables.Count)
End Sub


Private Function MakeTable(c1Name As String, c2Name As String) _
    As DataTable
    Dim table As New DataTable
    
    ' Add two DataColumns
    Dim column As New DataColumn( _
        c1Name, System.Type.GetType("System.Integer"))
    table.Columns.Add(column)
    column = New DataColumn(c2Name, _
        System.Type.GetType("System.String"))
    table.Columns.Add(column)
    MakeTable = table
End Function

Remarks

A name for the DataSet is required to ensure that the XML representation of the DataSet always has a name for the document element, which is the highest level element in a schema definition.

Applies to

.NET 9 ja muud versioonid

Toode	Versioonid
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

DataSet(SerializationInfo, StreamingContext)

Source:: DataSet.cs

Source:: DataSet.cs

Source:: DataSet.cs

Caution

This API supports obsolete formatter-based serialization. It should not be called or extended by application code.

Initializes a new instance of the DataSet class with serialized data.

protected:
 DataSet(System::Runtime::Serialization::SerializationInfo ^ info, System::Runtime::Serialization::StreamingContext context);

protected DataSet (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context);

[System.Obsolete("This API supports obsolete formatter-based serialization. It should not be called or extended by application code.", DiagnosticId="SYSLIB0051", UrlFormat="https://aka.ms/dotnet-warnings/{0}")]
protected DataSet (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context);

new System.Data.DataSet : System.Runtime.Serialization.SerializationInfo * System.Runtime.Serialization.StreamingContext -> System.Data.DataSet

[<System.Obsolete("This API supports obsolete formatter-based serialization. It should not be called or extended by application code.", DiagnosticId="SYSLIB0051", UrlFormat="https://aka.ms/dotnet-warnings/{0}")>]
new System.Data.DataSet : System.Runtime.Serialization.SerializationInfo * System.Runtime.Serialization.StreamingContext -> System.Data.DataSet

Protected Sub New (info As SerializationInfo, context As StreamingContext)

Parameters

info: SerializationInfo

The serialized data for the data set.

context: StreamingContext

Contextual information about the serialized stream.

Attributes: ObsoleteAttribute

Exceptions

InvalidEnumArgumentException

.NET 7 and later versions only: info contains binary data.

Remarks

Oluline

Using an instance of this object with untrusted data is a security risk. Use this object only with trusted data. For more information, see Validate All Inputs.

Applies to

.NET 9 ja muud versioonid

Toode	Versioonid (aegunud)
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7 (8, 9)
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

DataSet(SerializationInfo, StreamingContext, Boolean)

Source:: DataSet.cs

Source:: DataSet.cs

Source:: DataSet.cs

Caution

This API supports obsolete formatter-based serialization. It should not be called or extended by application code.

Initializes a new instance of the DataSet class with serialized data.

protected:
 DataSet(System::Runtime::Serialization::SerializationInfo ^ info, System::Runtime::Serialization::StreamingContext context, bool ConstructSchema);

protected DataSet (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context, bool ConstructSchema);

[System.Obsolete("This API supports obsolete formatter-based serialization. It should not be called or extended by application code.", DiagnosticId="SYSLIB0051", UrlFormat="https://aka.ms/dotnet-warnings/{0}")]
protected DataSet (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context, bool ConstructSchema);

new System.Data.DataSet : System.Runtime.Serialization.SerializationInfo * System.Runtime.Serialization.StreamingContext * bool -> System.Data.DataSet

[<System.Obsolete("This API supports obsolete formatter-based serialization. It should not be called or extended by application code.", DiagnosticId="SYSLIB0051", UrlFormat="https://aka.ms/dotnet-warnings/{0}")>]
new System.Data.DataSet : System.Runtime.Serialization.SerializationInfo * System.Runtime.Serialization.StreamingContext * bool -> System.Data.DataSet

Protected Sub New (info As SerializationInfo, context As StreamingContext, ConstructSchema As Boolean)

Parameters

info: SerializationInfo

The serialized data for the data set.

context: StreamingContext

Contextual information about the serialized stream.

ConstructSchema: Boolean

Attributes: ObsoleteAttribute

Exceptions

InvalidEnumArgumentException

.NET 7 and later versions only: info contains binary data.

Remarks

Oluline

Using an instance of this object with untrusted data is a security risk. Use this object only with trusted data. For more information, see Validate All Inputs.

Applies to

.NET 9 ja muud versioonid

Toode	Versioonid (aegunud)
.NET	Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7 (8, 9)
.NET Framework	2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

Microsoft Ignite

Jagamisviis:

DataSet Constructors

Definition

Overloads

DataSet()

Examples

Remarks

See also

Applies to

DataSet(String)

Parameters

Examples

Remarks

See also

Applies to

DataSet(SerializationInfo, StreamingContext)

Parameters

Exceptions

Remarks

Applies to

DataSet(SerializationInfo, StreamingContext, Boolean)

Parameters

Exceptions

Remarks

Applies to

Lisaressursid