ServerConnection Methods

  • Article

Public Methods

(see also Protected Methods )

  Name Description
ms218676.pubmethod(en-US,SQL.90).gif BeginTransaction
Starts a transaction on the referenced connection.
ms218676.pubmethod(en-US,SQL.90).gif Cancel
Cancels the connection.
ms218676.pubmethod(en-US,SQL.90).gif ChangePassword Overloaded.
Changes the logon password that is used with standard authentication.
ms218676.pubmethod(en-US,SQL.90).gif CommitTransaction
Commits the current transaction on the referenced connection.
ms218676.pubmethod(en-US,SQL.90).gif Connect 
Connects to the instance of SQL Server.
(inherited from ConnectionManager )
ms218676.pubmethod(en-US,SQL.90).gif Copy
Returns a copy of the ServerConnection object.
ms218676.pubmethod(en-US,SQL.90).gif Disconnect 
Disconnects from the instance of SQL Server.
(inherited from ConnectionManager )
ms218676.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms218676.pubmethod(en-US,SQL.90).gif ExecuteNonQuery Overloaded.
Executes a statement that does not return a result set.
ms218676.pubmethod(en-US,SQL.90).gif ExecuteReader
Executes Transact-SQL statements that return one or multiple result sets.
ms218676.pubmethod(en-US,SQL.90).gif ExecuteScalar Overloaded.
Executes a Transact-SQL statement and returns the first column of the first row as a value type.
ms218676.pubmethod(en-US,SQL.90).gif ExecuteWithResults Overloaded.
Executes one or more Transact-SQL statements that return one or more result sets.
ms218676.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms218676.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms218676.pubmethod(en-US,SQL.90).gif IsInFixedServerRole
Tests whether the logon associated with the referenced connection is a member of the specified fixed server role.
ms218676.pubmethod(en-US,SQL.90).gifms218676.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms218676.pubmethod(en-US,SQL.90).gif RollBackTransaction
Rolls back the current transaction.
ms218676.pubmethod(en-US,SQL.90).gif ToString 
Returns the referenced object name as a string.
(inherited from ConnectionSettings )

Protected Methods

  Name Description
ms218676.protmethod(en-US,SQL.90).gif CheckServerVersion  (inherited from ConnectionManager )
ms218676.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms218676.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms218676.protmethod(en-US,SQL.90).gif ThrowIfPropertyNotSet  Overloaded. (inherited from ConnectionSettings )

See Also

Reference

ServerConnection Class
Microsoft.SqlServer.Management.Common Namespace

Other Resources

How to: Connect to the Local Instance of SQL Server by Using Windows Authentication in Visual Basic .NET
Connecting to an Instance of SQL Server