ASP.NET Web Pages - Database Object
ASP.NET Database Object Reference Manual
- Close()
- Close the opened database.
- Dispose()
- Release all resources used by the Database instance.
- Database.Execute(SQLstatement [, parameters)
- Execute an SQL statement and return the number of affected records.
- Database.GetLastInsertId()
- Return the identifier column of the last inserted row.
- Database.Open(filename)
Database.Open(connectionStringName)
- Open a connection to the database using the specified filename or connection string.
- Database.OpenConnectionString(connectionString)
- Open a connection to the database using the specified connection string.
- Database.Query(SQLstatement[, parameters])
- Execute an SQL query, which will return a list of rows as a result.
- Database.QuerySingle(SQLstatement [, parameters])
- Execute an SQL query, which will return a single row as a result.
- Database.QueryValue(SQLstatement [, parameters])
- Execute an SQL query, which will return a scalar value as a result.
