DataSet Constructors

Definition

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.

See also

Applies to

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.

See also

Applies to

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

Exceptions

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

Remarks

Important

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

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

Exceptions

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

Remarks

Important

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