The SQLServerDataSet type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | SQLServerDataSet(String, String, String, String, String) |
Creates a new instance of the SQLServerDataSet representing an existing table.
|
| SQLServerDataSet(String, String, String, String, String, IEnumerable<(Of <<'(DBColumn>)>>)) |
Creates a new instance of the SQLServerDataSet representing a table that does not yet exist.
|
Methods
| Name | Description | |
|---|---|---|
| CloseConnection |
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.) |
| CommitTransaction |
Ends a transaction by committing all changes.
(Inherited from OleDbDataSet.) |
| CreateTable |
Creates a new table in the database or a new file containing the fields in the Fields property.
(Inherited from OleDbDataSet.) |
| Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
 | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
| GetEnumerator | Returns an enumerator that iterates through the collection. (Inherited from OleDbDataSet.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| OpenConnection |
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.) |
| PrepareForWrite |
Prepares the data set for one or more calls to WriteRecord(IDictionary<(Of <<'(DBColumn, Object>)>>)).
(Inherited from OleDbDataSet.) |
| RollbackTransaction |
Ends a transaction by reverting all changes.
(Inherited from OleDbDataSet.) |
| StartTransaction |
Begins a transaction. Transactions must be ended by calling either CommitTransaction()()()() or RollbackTransaction()()()() (Inherited from OleDbDataSet.) |
| ToString | Returns a String that represents the current Object. (Inherited from Object.) |
| WriteRecord |
Writes a single record to the database.
(Inherited from OleDbDataSet.) |
Properties
| Name | Description | |
|---|---|---|
 | ConnectionState |
The state of the connection to the database or the source file.
(Inherited from OleDbDataSet.) |
| Database |
The name of the database where the table is located.
|
 | DBMS | (Inherited from OleDbDataSet.) |
| Fields |
The columns in the data source.
(Inherited from OleDbDataSet.) |
| Password |
The user's password.
|
| Server |
The name of the server where the database is located.
|
| TableName |
The database table or file path where the data resides.
(Inherited from OleDbDataSet.) |
| User |
The user that has access to the table.
|
