I have 6 columns in a table -
Name, Address1, Address2, Address3, Address4, ZipCode

Each entry in the table will always have a Name but won't necessarily have a value in every Address field

What is the best way to pull this data out and display it?

I currently have 5 labels which display the values from each column like so:

Mr Jones
Floor 2
23 Some Road
Sometown
Somehere
12345

But if there is an entry which has an empty column I get an ugly space:

Mr Jones
Floor 2
23 Some Road
Sometown

12345

I can't work out how to display data from the 4 different address columns in one object so that this empty space doesn't appear.

I'm sure this is easy but I can't se hwo to do it.

I'm confused... do you want to show your data in a flow layout or in a columnar layout?

Sorry - I'll try and explain better. I don't want to use a column based layout like a datagrid so I'm currently doing it in a flow layout like this. I have 6 labels which are bound to the separate data fields as such:

cnConnection.Open()
dr = cmdSelectDetails.ExecuteReader
If dtrCentre.Read() Then
            lblName.Text = dtrCentre("mailname")
            lblAddress1.Text = dtrCentre("add_1")
            lblAddress2.Text = dtrCentre("add_2")
            lblAddress3.Text = dtrCentre("add_3")
            lblAddress4.Text = dtrCentre("add_4")
            lblPostcode.Text = dtrCentre("postcode")
End if
cnConnection.Close()

The HTML for these is then as follows:

<P>
<asp:Label id="lblAddress1" runat="server">Label</asp:Label><BR>
<asp:Label id="lblAddress2" runat="server">Label</asp:Label><BR>
<asp:Label id="lblAddress3" runat="server">Label</asp:Label><BR>
<asp:Label id="lblAddress4" runat="server">Label</asp:Label><BR>
<asp:Label id="lblPostcode" runat="server">Label</asp:Label>
</P>

What then happens is if all the labels aren't filled the linebreaks obviously still appear meaning I get the gaps as mentioned above.

What I need is a way to feed the 5 values into one object so that it doesn't matter if they don't appear

What about a single label and few tests?

AddLine(dtrCentre("mailname"))
AddLine(dtrCentre("add_1"))
AddLine(dtrCentre("add_2"))
AddLine(dtrCentre("add_3"))
AddLine(dtrCentre("add_4"))
AddLine(dtrCentre("postcode"))


Sub AddLine(strText As String)
    If strText.Length > 0 Then
        lblAddress.Text &= String.Format("{0}<br>", strText)
    End If
End Sub

Thats it - this method occurred to me after I posted this but I couldn't work out how to do it!

Thanks so much for your help. I really appreciate it