For the SqlDataSource control to be able to retrieve database data, two pieces of information were required: the database's connection string and the query to issue to the database. As we discussed in the preceding section, the query issued to the database must be in a dialect that the database understands. The common dialect among all modern database systems is SQL, or the Structured Query Language. To retrieve data from a database, we use a SQL SELECT statement. The SELECT statement, in its simplest form, specifies what database table to retrieve data from, along with what columns of data to return. For example, to return the title of each book in the Books table, we would use the following SQL statement: SELECT Title FROM Books We will examine the SQL SELECT clause in great detail in the next section. Although SQL is used primarily for retrieving database data, it can also be used to insert new data and update or delete existing data. These data modification capabilities are expressed using INSERT, UPDATE, and DELETE statements.
|