Examining the HTML

It's helpful to view the Authors.aspx source to see how VWD has configured //配置the various controls, especially the SqlDataSource control. Notice that the SQL statements //SQL语句are embedded in the ASPX source.

    <asp:SqlDataSource id="authorsSqlDataSource" runat="server"
UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] =
@au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state,
[zip] = @zip, [contract] = @contract WHERE [au_id] = @original_au_id"
SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [address], [city],
[state], [zip], [contract] FROM [authors]"
InsertCommand="INSERT INTO [authors] ([au_id], [au_lname], [au_fname], [phone],
[address], [city], [state], [zip], [contract]) VALUES (@au_id, @au_lname, @au_fname,
@phone, @address, @city, @state, @zip, @contract)"
DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @original_au_id"
ProviderName="<%$ ConnectionStrings:pubsConnectionString1.ProviderName %>"
ConnectionString="<%$ ConnectionStrings:pubsConnectionString1 %>"
<DeleteParameters>
<asp:Parameter Name="original_au_id" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="contract" Type="Boolean" />
<asp:Parameter Name="original_au_id" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="au_id" Type="String" />
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="contract" Type="Boolean" />
</InsertParameters>
</asp:SqlDataSource>

This can be very handy//方便的,手边的, though it may not be suitable//合适的 in all situations. You can still place database statements into stored procedures //存储过程or ad hoc within a data access layer//层. You'll learn more about using a data access layer in the lessons that follow.