Can anyone see why my Edit link will not work? I can't. but I am a newbie to ASP.NET so that doesn't mean much. Thanks for your time! I know it is a lot of code to read...
Code:
<html>
<asp:datalist id="DataList1" runat="server" Height="230px" OnEditCommand="Edit_Command"
OnCancelCommand="Cancel_Command"
EnableViewState="False" RepeatColumns="1" BorderColor="#E7E7FF" GridLines="Horizontal" BorderWidth="1px"
BorderStyle="None" BackColor="White" CellPadding="1" DataKeyField="ConsumerAccountNumber"
OnDeleteCommand="Delete_Command" OnUpdateCommand="Update_Command">
<HeaderTemplate>
Current Debtors
</HeaderTemplate>
<SelectedItemStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#738A9C"></SelectedItemStyle>
<AlternatingItemStyle BackColor="#F7F7F7"></AlternatingItemStyle>
<FooterStyle ForeColor="#4A3C8C" BackColor="#B5C7DE"></FooterStyle>
<ItemStyle ForeColor="#4A3C8C" BackColor="#E7E7FF"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#4A3C8C"></HeaderStyle>
<ItemTemplate>
<TABLE cellSpacing="1" cellPadding="1" width="100%" border="0">
<TR>
<td>
<asp:LinkButton Text="Edit" CommandName="edit" Runat="server"></asp:LinkButton></td>
<td>
<asp:Label id="Label1" runat="server" text='<%# Databinder.Eval(container.dataitem,"ConsumerAccountNumber") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label2" runat="server" text='<%# Databinder.Eval(container.dataitem,"LastName") %>'>Label</asp:Label>
<asp:Label id="Label5" runat="server">,</asp:Label>
<asp:Label id="Label3" runat="server" text='<%# Databinder.Eval(container.dataitem,"FirstName") %>'>Label</asp:Label>
<asp:Label id="Label4" runat="server" text='<%# Databinder.Eval(container.dataitem,"MiddleName") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label7" runat="server" text='<%# Databinder.Eval(container.dataitem,"FirstLineOfAddress") %>'>Label</asp:Label>
<asp:Label id="Label9" runat="server">,</asp:Label>
<asp:Label id="Label8" runat="server" text='<%# Databinder.Eval(container.dataitem,"SecondLineOfAddress") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label10" runat="server" text='<%# Databinder.Eval(container.dataitem,"City") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label11" runat="server" text='<%# Databinder.Eval(container.dataitem,"State") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label12" runat="server" text='<%# Databinder.Eval(container.dataitem,"ZipCode") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label6" runat="server" text='<%# Databinder.Eval(container.dataitem,"CurrentBalance", "{0:c}") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label13" runat="server" text='<%# Databinder.Eval(container.dataitem,"SocialSecurityNumber") %>'>Label</asp:Label>
</td>
<td>
<asp:Label id="Label14" runat="server" text='<%# Databinder.Eval(container.dataitem,"TelephoneNumber") %>'>Label</asp:Label>
</td>
</TR>
</TABLE>
</ItemTemplate>
<EditItemTemplate>
<table>
<tr>
<td>Acct. No:</td>
<asp:Label id="Label17" runat="server" text='<%# Databinder.Eval(container.dataitem,"ConsumerAccountNumber") %>'/>
<td>Last Name</td>
<td>
<asp:TextBox id="txtLastName" Text='<%# Databinder.Eval(container.dataitem,"LastName") %>' runat="server"/></td>
<td>
<asp:LinkButton Text="Update" CommandName="update" runat="server" />
<asp:LinkButton Text="Cancel" CommandName="cancel" runat="server" />
</td>
</tr>
</table>
</EditItemTemplate>
</asp:datalist>
</html>
Code:
Private Sub LoadData()
Dim conn As SqlConnection
Dim cmd As SqlCommand
Dim reader As SqlDataReader
conn = New SqlConnection(ConfigurationSettings.AppSettings().Item("strConn"))
cmd = New SqlCommand("SELECT ConsumerAccountNumber,CurrentBalance,LastName,FirstName,MiddleName, " & _
"SocialSecurityNumber,TelephoneNumber,FirstLineOfAddress,SecondLineOfAddress,City, " & _
"State,ZipCode FROM CustomerRecords WHERE UserName = '" & username & "'", conn)
Try
conn.Open()
reader = cmd.ExecuteReader()
Catch ex As SqlException
Throw
Finally
DataList1.DataSource = reader
DataList1.DataBind()
reader.Close()
conn.Close()
conn.Dispose()
End Try
End Sub
Code:
Sub Edit_Command(ByVal sender As Object, ByVal e As DataListCommandEventArgs)
DataList1.EditItemIndex = e.Item.ItemIndex
LoadData()
End Sub
Linear Mode
