共用方式為


ServerConnection Members

The ServerConnection object represents a connection to a server.

The following tables list the members exposed by the ServerConnection type.

Public Constructors

  名稱 Description
ServerConnection Overloaded. Initializes a new instance of the ServerConnection class.

頂端

Public Properties

  名稱 Description
ms218680.pubproperty(zh-tw,SQL.90).gif ApplicationName  Gets or sets the name of the application that has established the connection with the server. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif AutoDisconnectMode  Gets or sets the automatic disconnection mode of the referenced connection to the instance of SQL Server. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif BatchSeparator Gets or sets the string value used to separate batches in the referenced connection.
ms218680.pubproperty(zh-tw,SQL.90).gif CapturedSql  Gets the Transact-SQL statements that are captured when the connection is running in capture mode. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif ConnectAsUser  Gets or sets the Boolean property value that specifies whether the connection is established using impersonation. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ConnectAsUserName  Gets or sets the name of the user when connecting using impersonation. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ConnectAsUserPassword  Gets or sets the password for the user when connecting using impersonation. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ConnectionString  Gets or sets the connection string used to establish a connection with a specified data source. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ConnectTimeout  Gets or sets the connection time-out period in seconds. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif DatabaseName  Gets or sets the database required by the connection. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif EncryptConnection  Gets or sets the Boolean property value that specifies whether the connection is encrypted. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif FixedServerRoles Gets the fixed server role associated with the referenced connection.
ms218680.pubproperty(zh-tw,SQL.90).gif InUse  Gets or sets the Boolean property value that specifies whether the connection is being used. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif IsOpen  Gets the Boolean property value that specifies whether the connection is currently open. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif LockTimeout  Gets or sets the time in seconds required for the connection to time out when the current transaction is locked. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif Login  Gets or sets the logon required to establish a connection with the instance of the server. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif LoginSecure  Gets or sets the Boolean property that specifies whether the connection is established to the server by using Windows Authentication or SQL Server Authentication. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif MaxPoolSize  Gets or sets the maximum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif MinPoolSize  Gets or sets the minimum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif MultipleActiveResultSets  Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif NetworkProtocol  Gets or sets the network protocol used to establish the connection to the server. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif NonPooledConnection  Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif PacketSize  Gets or sets the packets of data sent between the client and the server over the network in bytes. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif Password  Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif PooledConnectionLifetime  Gets or sets the lifetime of the pooled connection. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ProcessID Gets the ID value that uniquely identifies the process associated with the referenced connection to the server.
ms218680.pubproperty(zh-tw,SQL.90).gif SecurePassword  Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ServerInstance  Gets or sets the name of the server. (inherited from ConnectionSettings)
ms218680.pubproperty(zh-tw,SQL.90).gif ServerVersion  Gets the version of the connected instance of SQL Server. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif SqlConnectionObject  Gets the connection object. (inherited from ConnectionManager)
ms218680.pubproperty(zh-tw,SQL.90).gif SqlExecutionModes Gets or sets the execution mode associated with the referenced connection to the server.
ms218680.pubproperty(zh-tw,SQL.90).gif StatementTimeout Gets or sets the number of seconds a statement is given to run before failing with a time-out error.
ms218680.pubproperty(zh-tw,SQL.90).gif TransactionDepth Gets the current transaction depth for the referenced connection.
ms218680.pubproperty(zh-tw,SQL.90).gif TrueLogin Gets the current logon record name used by the referenced connection.
ms218680.pubproperty(zh-tw,SQL.90).gif TrueName Gets the name of the server.
ms218680.pubproperty(zh-tw,SQL.90).gif UserProfile Gets the user profile associated with the referenced connection.
ms218680.pubproperty(zh-tw,SQL.90).gif WorkstationId  Gets or sets the ID value that uniquely identifies the workstation. (inherited from ConnectionSettings)

頂端

Public Methods

(see also Protected Methods )

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

頂端

Protected Methods

  名稱 Description
ms218680.protmethod(zh-tw,SQL.90).gif CheckServerVersion  (inherited from ConnectionManager )
ms218680.protmethod(zh-tw,SQL.90).gif Finalize  (inherited from Object )
ms218680.protmethod(zh-tw,SQL.90).gif MemberwiseClone  (inherited from Object )
ms218680.protmethod(zh-tw,SQL.90).gif ThrowIfPropertyNotSet  Overloaded. (inherited from ConnectionSettings )

頂端

Public Events

  名稱 Description
ms218680.pubevent(zh-tw,SQL.90).gif InfoMessage  The event that occurs when the instance of SQL Server generates an informational message. (inherited from ConnectionManager)
ms218680.pubevent(zh-tw,SQL.90).gif RemoteLoginFailed  This event occurs when a remote login fails to connect to the instance of SQL Server. (inherited from ConnectionManager)
ms218680.pubevent(zh-tw,SQL.90).gif ServerMessage  The event that occurs when the instance of SQL Server generates a message. (inherited from ConnectionManager)
ms218680.pubevent(zh-tw,SQL.90).gif StateChange  The event that occurs when the instance of SQL Server changes state. (inherited from ConnectionManager)
ms218680.pubevent(zh-tw,SQL.90).gif StatementExecuted  The event that occurs when the instance of SQL Server executes a statement on the current connection. (inherited from ConnectionManager)

頂端

請參閱

參考

ServerConnection Class
Microsoft.SqlServer.Management.Common Namespace

其他資源

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