ASP.NET Web Pages - Database Object
ASP.NET Database Object Reference Manual
| Methods | Description |
|---|---|
| Database.Execute(SQLstatement [, parameters]) | Executes SQL statements SQLstatement(with optional parameters), such as INSERT, DELETE, or UPDATE, and returns the count of affected records. |
| Database.GetLastInsertId() | Returns the identity column of the most recently inserted row. |
| Database.Open(filename) Database.Open(connectionStringName) |
UsesWeb.configOpens the specified database file or the specified database using a connection string from a file. |
| Database.OpenConnectionString(connectionString) | Opens a database using a connection string. (The difference from Database.Open is that Database.Open uses the name of the connection string, whose value is configured elsewhere.) |
| Database.Query(SQLstatement[, parameters]) | Uses SQL statementsSQLstatement(with optional parameters) to query the database and returns a result set. |
| Database.QuerySingle(SQLstatement [, parameters]) | Executes SQL statementsSQLstatement(with optional parameters) and returns a single record. |
| Database.QueryValue(SQLstatement [, parameters]) | Executes SQL statementsSQLstatement(with optional parameters) and returns a single value. |
Other extensions