datalist disappears...why?

brendalisalowe · 05-17-2005, 12:39 PM

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