Get data from DataList cell?

[NapstrPSX]

I have a datalist, named: dlstScannedDocuments.

The DataKeyField is FileName, and I am able to retrieve it by using:

dlstScannedDocuments.DataKeys(e.Item.ItemIndex)

The template for the datalist looks like this:

<ItemTemplate>
                            <table border="0" cellspacing="0" width="100%" id="tblScannedDocuments" cellpadding="0">
                                <tr>
                                    <td width="25%" align="left">
                                        <asp:LinkButton ID="Linkbutton3" runat="server" Text="View">
                                        </asp:LinkButton>
                                    </td>
                                    <td width="25%%" colspan="1" align="left">
                                        <%#Container.DataItem("LobDocumentType")%>
                                    </td>
                                    <td width="25%" align="center" colspan="1">
                                        <%#String.Format("{0:d}", Container.DataItem("LobDateReceived"))%>
                                    </td>
                                    <td width="25%" align="center" colspan="1">
                                        <%#String.Format("{0:d}", Container.DataItem("LobScanDate"))%>
                                    </td>
                                    <td width="25%%" colspan="1" align="left" style="display:none">
                                        <%#Container.DataItem("LobReportYear")%>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>

How can I retrieve what is in the LobReportYear cell for a record? For the life of me I cannot figure out how to do it anywhere. Any help very much appreciated, thank you.

 

[kulrom]

Once you get the table (HtmlTable) you can get the innertext of the particular cell (HtmlTableCell) by indexing. e.g.

Dim Years As New Genric.List(of String)
For Each row As HtmlTableRow In table.Rows
    Years.Add(CType(row.Controls(4), HtmlTableCell).InnerText)
Next

However i suggest that you put all that in a Label control for easier referencing.

 

[NapstrPSX]

I have tried using a label control but I don't know how to do it. I haven't seen good code in vb.net to help.

I also don't really know what you're talking about in this reply... could you or someone else please break it down a bit more? it is all stored in HTML tables.

 

[kulrom]

i guess you do not understand the explanation. otherwise it sounds very rude (that you don't know what i'm talking about). In addition, i am pretty sure that HERE nobody else can help you with this except me.

 

[NapstrPSX]

I was not trying to be rude, I am just ignorant. For instance I don't know what you are referring to when you say:

Once you get the table (HtmlTable)

 

[kulrom]

well this is the only table in that itemtemplate so normaly it will be item.controls(0). You just need to cast the table. then you have the start point. Maybe you should consider adding runat=server to the table and reference it more easier.