I cannot figure out how to get this simple DataList to update, I have the C# Beginning 2005 Databases - Watson, but I am just not getting it. Trie dusing Bind instead of Eval - no good. What do I need to do to edit the (int) L_Rank, (string) L_City and L_State? I am just not getting it. I have eight WROX books and an really confused. Any help GREATLY appreciated. Thank you.


<asp:DataList ID="DataList1" runat="server" DataSourceID="LinkInfoDataSource" OnEditCommand="myEditListHandler" OnCancelCommand="DataList1_CancelCommand" OnUpdateCommand="DataList1_UpdateCommand" >
<ItemTemplate>
            <asp:Label ID="L_IDLabel" runat="server" Text='<%# Eval("L_ID") %>'></asp:Label><br />
            <asp:Label ID="L_NameLabel" runat="server" Text='<%# Eval("L_Name") %>'></asp:Label><br />
            <asp:Label ID="L_RankLabel" runat="server" Text='<%# Eval("L_Rank") %>'></asp:Label><br />
            <asp:Label ID="L_CityLabel" runat="server" Text='<%# Eval("L_City") %>'></asp:Label><br />
            <asp:Label ID="L_StateLabel" runat="server" Text='<%# Eval("L_State") %>'></asp:Label><br />
            <asp:Button ID="Button1" runat="server" Text="Button" CommandName="edit" />
            <br />
        </ItemTemplate>
        <HeaderTemplate>
           <h3><b>
               <asp:Label ID="Label1" runat="server" BackColor="#FFC080" Font-Size="Larger" Text=" Basic Header Trial "></asp:Label></b>&nbsp;</h3>
        </HeaderTemplate>
        <SeparatorTemplate></SeparatorTemplate>
        <EditItemTemplate>
            EDIT Template<br />
            <asp:TextBox ID="L_IDTextBox" runat="server" Text='<%# Eval("L_ID") %>'></asp:TextBox><br />
            <asp:TextBox ID="L_NameTextBox" runat="server" Text='<%# Eval("L_Name") %>'></asp:TextBox><br />
            <asp:TextBox ID="L_RankTextBox" runat="server" Text='<%# Eval("L_Rank") %>'></asp:TextBox><br />
            <asp:TextBox ID="L_CityTextBox" runat="server" Text='<%# Eval("L_City") %>'></asp:TextBox><br />
            <asp:TextBox ID="L_StateTextBox" runat="server" Text='<%# Eval("L_State") %>'></asp:TextBox><br />
            <asp:Button ID="Button2" runat="server" Text="Update" CommandName="update" />
            <asp:Button ID="Button3" runat="server" Text="Cancel" CommandName="cancel" />
        </EditItemTemplate>
    </asp:DataList><asp:SqlDataSource ID="LinkInfoDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
        SelectCommand="SELECT [L_ID], [L_Name], [L_Rank], [L_City], [L_State] FROM [tblContractorLinkInfo] WHERE ([L_State] = @L_State)" >
        <SelectParameters>
            <asp:Parameter DefaultValue="va" Name="L_State" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>


CODE BEHIND *****

public partial class Basics : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    { }

    protected void myEditListHandler(Object src, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = e.Item.ItemIndex;
        DataList1.DataBind();
    }
    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = -1;
        DataList1.DataBind();
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    { }
}