ASP. NET Web Pages-Database object, pagesdatabase
ASP. NET Database object reference manual
-
Close ()
-
Close the opened database.
-
Dispose ()
-
Releases all resources used by the Database instance.
-
Database. Execute (SQLstatement [, parameters]
-
Execute the SQL statement and return the affected records.
-
Database. GetLastInsertId ()
-
Returns the ID column of the last inserted row.
-
Database. Open (filename)
Database. Open (connectionStringName)
-
Use the specified file name or connection string to open the connection to the database.
-
Database. OpenConnectionString (connectionString)
-
Use the specified connection string to open the connection to the database.
-
Database. Query (SQLstatement [, parameters])
-
Execute an SQL query. The query returns the list of rows as the result.
-
Database. QuerySingle (SQLstatement [, parameters])
-
Execute an SQL query. A row is returned as the result.
-
Database. QueryValue (SQLstatement [, parameters])
-
Execute an SQL query. a scalar value is returned as the result.