Easy Tutorial
❮ Prop Webcontrol Calendar Showgridlines Mvc Security ❯

ASP.NET Web Pages - Database Object

ASP.NET Database Object Reference Manual


Method Description
Database.Execute(SQLstatement [, parameters]) Executes the SQL statement 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) <br>Database.Open(connectionStringName) Opens the specified database file or the specified database using the connection string from the Web.config file.
Database.OpenConnectionString(connectionString) Opens a database using the connection string. (Unlike Database.Open, which uses the name of the connection string, the value of the connection string is configured elsewhere.)
Database.Query(SQLstatement [, parameters]) Queries the database using the SQL statement SQLstatement (with optional parameters) and returns the result set.
Database.QuerySingle(SQLstatement [, parameters]) Executes the SQL statement SQLstatement (with optional parameters) and returns a single record.
Database.QueryValue(SQLstatement [, parameters]) Executes the SQL statement SQLstatement (with optional parameters) and returns a single value.
❮ Prop Webcontrol Calendar Showgridlines Mvc Security ❯