This is sometimes called a master-details page. Create a page named petGridView.
ID: 3769270 • Letter: T
Question
This is sometimes called a master-details page. Create a page named petGridView.aspx with the main menu displayed as Update Customers. Drag the SQLDataSource control on the page and configure the control as directed in the lessons. The query should retrieve all the records in the Customers table, but only retrieve the customerlD, firstname and lastname fields. (Note that you may have used different field names and so adjust the query as needed.) Bind this list to a dropdownlist server control. You will have to drag and drop a dropdownlist control to the web page. Then, select the data source as the SOLDataSourcel control The displayed text should be the [lastname, firstname] where there is a comma and space between the names. The value should be the customer lD Change the auto-submit feature to be on, so when you click on the selection and make a change, the information is submitted. Create the second SQL DataSource control. Drag a second SQL DataSource control on the page and configure the control as you did earlier. Create the query to retrieve all customer orders from the ProductOrders table, for that customer. (Note that this means the ProductOrders table should have had a customerlD field to associate the two tables.) You will allow the customerlD value, to be retrieved from the dropdownlist control. (TIP: You v/ill need to use the WHERE button and build the WHERE clause. Select the value from the dropdownlist control.) You will need to enable the ability to update the table. Bind this SQL Data Source control to a GridView control. You will have to drag and drop the GridView control to the web page. Then, select the data source as the SQLDataSource2 control. Configure Allow the user to update but not delete this order as shown in the lesson and book.Explanation / Answer
1.<html xmlns="http://ww.w3.org//1999/xhtml">
<head runat="server">
<title>untitled page</title>
<head>
<body>
<form id="forml" runat="server">
<div>
<h1>mysite.com logo</h1>
<table width="100%">
<tr valign="top">
<td>
todo:menu
</td>
<td>
<asp:contentPlaceHolder ID="MainContent" runat="server">
</asp:ContentPlaceHolder>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
2.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.