Expand|Select|Wrap|Line Numbers
- PreparedStatement ps = new PreparedStatement("SELECT dbo.LDLB_File_DTL.FileDesc AS [FileDesc], dbo.LDLB_File_Index.FileName AS [FileName] FROM dbo.LDLB_File_DTL INNER JOIN dbo.LDLB_File_Index ON dbo.LDLB_File_DTL.FileID = dbo.LDLB_File_Index.FileID WHERE (dbo.LDLB_File_DTL.FileCollectionID = ?)");
- ps.setLong(1, long.Parse(lbCollection.SelectedValue));
- DBConnection conn = new DBConnection();
- conn.openConnection();
- dlResults.DataSource = conn.executeQuery(ps.ToString());
- dlResults.DataBind();
- ImageMultiView.ActiveViewIndex = 1;
- ImageMultiView.DataBind();
- conn.closeConnection();
[HTML]
<asp:DataList ID="dlResults" runat="server">
<ItemTemplate>
<table>
<tr>
<td>
<%#DataBinder.Eval(Container.DataItem,"FileDesc")% >
<%#DataBinder.Eval(Container.DataItem,"FileName" ) %>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>[/HTML]
I know its probably something simple that i missed any help would be greatly appreciated
Thanks