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 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.