Shunde.NET Framework Class Library

DBUtils Methods

The methods of the DBUtils class are listed below. For a complete list of DBUtils class members, see the DBUtils Members topic.

Public Static Methods

BeginTransaction Starts an Sql Transaction
CloseSqlConnectionCloses the database connection for the current HttpContext
CommitTransaction Commits the currently started Sql Transaction
ExecuteSqlCommandOverloaded. Executes a non-query SQL Command
ExecuteSqlQueryOverloaded. Executes an SQL Query
GetBoolValueGets a boolean Value from the given SqlDataReader
GetDateTimeValueGets a DateTime Value from the given SqlDataReader
GetIntFromSqlSelectOverloaded. Executes an SQL Query that is known to return just one integer Value
GetIntValueGets an int Value from the given SqlDataReader
getIntValueMayBeNullGets an int Value from the given SqlDataReader, where the int Value may be null
GetSqlConnectionGets the SqlConnection
GetSqlDbTypeGets the SqlDataType for the given column
HasRowsExecutes the given SQL Query and returns a boolean indicating whether 1 or more rows were returned
ParseSqlOverloaded. Escapes all apostrophes in an SQL Statement.
RollbackTransaction Rolls back the current Sql Transaction
SetSqlConnectionEach HttpContext has it's own SqlConnection. This method sets the SqlConnection, ready to be used.

Public Instance Methods

Equals (inherited from Object)Determines whether the specified Object is equal to the current Object.
GetHashCode (inherited from Object)Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetType (inherited from Object)Gets the Type of the current instance.
ToString (inherited from Object)Returns a String that represents the current Object.

Protected Instance Methods

Finalize (inherited from Object)Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
MemberwiseClone (inherited from Object)Creates a shallow copy of the current Object.

See Also

DBUtils Class | Shunde.Utilities Namespace