[About] Version=1.0 Author=Nic Mail=support@hiasm.com [Type] Class=Element Inherit=DbConnection Interfaces=Component,MarshalByRefObject,Object,SqlConnection Info=Represents an open connection to a SQL Server database [Property] Name=Sets the name of the component. ARG(string)|2| Constructor=Sets the Constructor of the SqlConnection class. ARG(enum)|14|0|Constructor,Constructor2 +@ConnectionStr=Sets the string used to open a SQL Server database. ARG(string)|2| @FireInfoMessageEventOnUserErrors=Sets the FireInfoMessageEventOnUserErrors property. ARG(bool)|14|1|True,False @StatisticsEnabled=When set to true, enables statistics gathering for the current connection. ARG(bool)|14|1|True,False [Methods] *doBeginTransaction2=Starts a database transaction with the specified isolation level. ARG(IsolationLevel iso)|1|0 *doBeginTransaction3=Starts a database transaction with the specified transaction name. ARG(string transactionName)|1|0 *doBeginTransaction4=Starts a database transaction with the specified isolation level and transaction name. ARG(IsolationLevel iso, string transactionName)|1|0 *doChangeDatabase=Changes the current database for an open SqlConnection. ARG(string database)|1|0 *doChangePassword=Changes the SQL Server password for the user indicated in the connection string to the supplied new password. ARG(string connectionString, string newPassword)|1|0 *doClearAllPools=Empties the connection pool. ARG()|1|0 *doClearPool=Empties the connection pool associated with the specified connection. ARG(SqlConnection connection)|1|0 *doClose=Closes the connection to the database. This is the preferred method of closing any open connection. ARG()|1|0 *doConstructor=Initializes a new instance of the SqlConnection class. ARG()|1|0 *doConstructor2=Initializes a new instance of the SqlConnection class when given a string that contains the connection string. ARG(string ConnectionStr)|1|0 *doEnlistDistributedTransaction=Enlists in the specified transaction as a distributed transaction. ARG(ITransaction transaction)|1|0 *doEnlistTransaction=Enlists in the specified transaction as a distributed transaction. ARG(Transaction transaction)|1|0 *doGetSchema2=Returns schema information for the data source of this SqlConnection using the specified string for the schema name. ARG(string collectionName)|1|0 *doGetSchema3=Returns schema information for the data source of this SqlConnection using the specified string for the schema name and the specified string array for the restriction values. ARG(string collectionName, string[] restrictionValues)|1|0 doOpen=Opens a database connection with the property settings specified by the ConnectionString. ARG()|1|0 *doResetStatistics=If statistics gathering is enabled, all values are reset to zero. ARG()|1|0 *onBeginTransaction=Occurs after invoke the method doBeginTransaction and returns the result. ARG(SqlTransaction)|2|0 *onGetSchema=Occurs after invoke the method doGetSchema and returns the result. ARG(DataTable)|2|0 *onInfoMessage=Occurs when SQL Server returns a warning or informational message. ARG(SqlInfoMessageEventArgs)|2|0 *BeginTransaction=Starts a database transaction. ARG(SqlTransaction)|3|0 *ConnectionString=Returns the string used to open a SQL Server database. ARG(string)|3|2 *ConnectionTimeout=Returns the time to wait while trying to establish a connection before terminating the attempt and generating an error. ARG(int)|3|1 *CreateCommand=Creates and returns a SqlCommand object associated with the SqlConnection. ARG(SqlCommand)|3|0 *Database=Returns the name of the current database or the database to be used after a connection is opened. ARG(string)|3|2 *DataSource=Returns the name of the instance of SQL Server to which to connect. ARG(string)|3|2 *FireInfoMessageEventOnUserErrors=Returns the FireInfoMessageEventOnUserErrors property. ARG(bool)|3|104 *GetSchema=Returns schema information for the data source of this SqlConnection. ARG(DataTable)|3|0 *PacketSize=Returns the size of network packets used to communicate with an instance of SQL Server. ARG(int)|3|1 *RetrieveStatistics=Returns a name value pair collection of statistics at the point in time the method is called. ARG(IDictionary)|3|0 *ServerVersion=Returns a string that contains the version of the instance of SQL Server to which the client is connected. ARG(string)|3|2 *State=Indicates the state of the SqlConnection when the most recent network operation was performed on the connection. ARG(ConnectionState)|3|0 *StatisticsEnabled=When set to true, enables statistics gathering for the current connection. ARG(bool)|3|104 *WorkstationId=Returns a string that identifies the database client. ARG(string)|3|2 SqlConnection=Returns the SqlConnection object. ARG(SqlConnection)|3|0 *collectionName=Specifies the name of the schema to return. ARG(string)|4|2 *connection=The SqlConnection to be cleared from the pool. ARG(SqlConnection)|4|0 ConnectionStr=The connection used to open the SQL Server database. ARG(string)|4|2 *database=The name of the database to use instead of the current database. ARG(string)|4|2 *iso=The isolation level under which the transaction should run. ARG(IsolationLevel)|4|0 *newPassword=The new password to set. This password must comply with any password security policy set on the server, including minimum length, requirements for specific characters, and so on. ARG(string)|4|2 *restrictionValues=A set of restriction values for the requested schema. ARG(string[])|4|13 *transaction=A reference to an existing ITransaction in which to enlist. ARG(ITransaction)|4|0 *transactionName=The name of the transaction. ARG(string)|4|2