The SQLServerDataSet type exposes the following members.

Constructors

  NameDescription
Public methodSQLServerDataSet(String, String, String, String, String)
Creates a new instance of the SQLServerDataSet representing an existing table.
Public methodSQLServerDataSet(String, String, String, String, String, IEnumerable<(Of <<'(DBColumn>)>>))
Creates a new instance of the SQLServerDataSet representing a table that does not yet exist.

Methods

  NameDescription
Public methodCloseConnection
Closes the connection to the database or, if the source is a file, closes the file. Ignored if connection is not open.
(Inherited from OleDbDataSet.)
Public methodCommitTransaction
Ends a transaction by committing all changes.
(Inherited from OleDbDataSet.)
Public methodCreateTable
Creates a new table in the database or a new file containing the fields in the Fields property.
(Inherited from OleDbDataSet.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetEnumerator
Returns an enumerator that iterates through the collection.
(Inherited from OleDbDataSet.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOpenConnection
Opens the connection to the database or, if the source is a file, opens the file. Ignored if connection is already open.
(Inherited from OleDbDataSet.)
Protected methodPrepareForWrite
Prepares the data set for one or more calls to WriteRecord(IDictionary<(Of <<'(DBColumn, Object>)>>)).
(Inherited from OleDbDataSet.)
Public methodRollbackTransaction
Ends a transaction by reverting all changes.
(Inherited from OleDbDataSet.)
Public methodStartTransaction
Begins a transaction. Transactions must be ended by calling either CommitTransaction()()()() or RollbackTransaction()()()()
(Inherited from OleDbDataSet.)
Public methodToString
Returns a String that represents the current Object.
(Inherited from Object.)
Public methodWriteRecord
Writes a single record to the database.
(Inherited from OleDbDataSet.)

Properties

  NameDescription
Public propertyConnectionState
The state of the connection to the database or the source file.
(Inherited from OleDbDataSet.)
Public propertyDatabase
The name of the database where the table is located.
Protected propertyDBMS (Inherited from OleDbDataSet.)
Public propertyFields
The columns in the data source.
(Inherited from OleDbDataSet.)
Public propertyPassword
The user's password.
Public propertyServer
The name of the server where the database is located.
Public propertyTableName
The database table or file path where the data resides.
(Inherited from OleDbDataSet.)
Public propertyUser
The user that has access to the table.

See Also