Chapter 15, Problem 14PE

Which of the following sort expressions would you use to sort the data in a GridView control by the FirstName column within the LastName column?a) FirstName, LastNameb) FirstName LastNamec) LastName, FirstNamed) LastName FirstName

Code example 13-1 <asp:SqlDataSource ID="SqlDataSource2" runat="server"    ConnectionString="Data Source=localhost\sqlexpress;        Initial Catalog=Halloween;Integrated Security=True"    SelectCommand="SELECT [InvoiceNumber], [OrderDate], [Total]        FROM [Invoices]        WHERE ([CustEmail] = @CustEmail)        ORDER BY [Total]">    <SelectParameters>        <asp:ControlParameter ControlID="ddlCustomers" Name="CustEmail"            PropertyName="SelectedValue" Type="String" />    </SelectParameters> </asp:SqlDataSource>     (Refer to code example 13-1.) Which of the following identifies the property that contains the value that will be used to determine the invoices that are included in the data source?   The @CategoryID parameter   The Name attribute of the ControlParameter element   The ControlID attribute of the ControlParameter element   The PropertyName attribute of the ControlParameter element

You can use the PagerSettings element of a GridView control to do all but one of the following. Which one is it?   Control what buttons appear in the pager area Control the number of rows that are displayed on a page   Control whether text or images appear on the page buttons Control where the pager area appears

What does the following SQL statement add to the Terms table?Insert Into Terms (TermsDueDays)Values (90)a) A row with a value of 90 for the TermsDueDays columnb) 90 rows with a column of TermsDueDaysc) All rows where the TermsDueDays column has a value of 90d) A TermsDueDays column with a default value of 90

What is the primary function of a data adapter? a).To define the connection to a databaseb) To manage the flow of data between a client program and a databased) To convert data to the format required by an applicationc) To define a SQL operation to be performed

What does a relational database use to uniquely identify each row in a table?a) indexesb) foreign keysc) non-primary keysd) primary keys

What happens when you click the Edit button for a row in a GridView control?a).The Edit button is replaced by Update and Cancel buttonsb). The editable bound fields are displayed in text boxesc). The Delete button is removedd).All of the abovee).A and B only

Which of the following isn’t true for a SiteMapPath control?a). It requires a SiteMapDataSource control.b).It shows the links that led to the current page.c).It lets you specify the number of parent nodes to display.d). It automatically uses the web.sitemap file.

// defining the pins const int green_led = 3;const int red_led = 5;const int yellow_led = 6;const int buzzer = 4;const int button_status = 12;const int button_fall = 11;const int button_safe = 10;const int potentiometer = A0; int pot_value;int button_fall_state;int button_safe_state;int last_button_fall_state;int buzzer_state;int threshold = 512; int button_status_state = 0; void setup() {  // put your setup code here, to run once:Serial.begin(9600);// Initializing digital pins as outputpinMode(green_led, OUTPUT);pinMode(red_led, OUTPUT);pinMode(yellow_led, OUTPUT);pinMode(buzzer, OUTPUT); // Initializing digital pins as inputspinMode(button_status, INPUT);pinMode(button_fall, INPUT);pinMode(button_safe, INPUT);// initializing analog pin as inputpinMode(potentiometer, INPUT); digitalWrite(buzzer, LOW);digitalWrite(yellow_led, LOW); } void loop() {  // read current state of the status button  button_status_state = digitalRead(button_status);     if (button_status_state == HIGH) {…