I am trying to display the URL link to some documents. I can get the document names to appear but it doesn't show the URL. If I remove the A Href, it prints the path to the file. I want the user to be able to click on the URL to open the document. What am I doing wrong? Is there a better way to do this?
Thanks,
Mapman04
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<title>ISO Document Search</title>
<script runat="server" language="VB">
Sub getData(s As Object, e As EventArgs)
Dim objConn As OleDbConnection
Dim objCmd As OleDbCommand
Dim objRdr As OleDbDataReader
objConn = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=F:\Files\adbWeb.mdb")
objCmd = New OleDbCommand("SELECT * FROM tblDocs WHERE fldKeyWord=@Name", objConn)
objCmd.Parameters.Add("@Name", txtSearch.Text)
objConn.Open()
objRdr = objCmd.ExecuteReader()
myRepeater.DataSource = objRdr
myRepeater.DataBind()
objRdr.Close()
objConn.Close()
End Sub
</script>
</head>
<body>
<IMG src=" Width="200" Height="100" />
<H2>ISO Document Search</H2>
<form runat="server">
<p><asp:TextBox id="txtSearch" runat="server"/>
<asp:Button id="btnSubmit" OnClick="getData" Text="Enter Search Word" runat="server"/></p>
<p><asp:Repeater id="myRepeater" runat="server">
<HeaderTemplate>
<table>
<tr>
<th>Document Name</th>
<th>URL Link</th>
</tr>
</HeaderTemplate>
<Itemtemplate>
<tr>
<td><%# Container.DataItem("fldDocName") %></td>
<td><A Href ="<%# Container.DataItem("fldDocLocation") %>"></A></td>
</tr>
</Itemtemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater></p>
</form>
</body>
</html>
Thanks,
Mapman04
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<title>ISO Document Search</title>
<script runat="server" language="VB">
Sub getData(s As Object, e As EventArgs)
Dim objConn As OleDbConnection
Dim objCmd As OleDbCommand
Dim objRdr As OleDbDataReader
objConn = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=F:\Files\adbWeb.mdb")
objCmd = New OleDbCommand("SELECT * FROM tblDocs WHERE fldKeyWord=@Name", objConn)
objCmd.Parameters.Add("@Name", txtSearch.Text)
objConn.Open()
objRdr = objCmd.ExecuteReader()
myRepeater.DataSource = objRdr
myRepeater.DataBind()
objRdr.Close()
objConn.Close()
End Sub
</script>
</head>
<body>
<IMG src=" Width="200" Height="100" />
<H2>ISO Document Search</H2>
<form runat="server">
<p><asp:TextBox id="txtSearch" runat="server"/>
<asp:Button id="btnSubmit" OnClick="getData" Text="Enter Search Word" runat="server"/></p>
<p><asp:Repeater id="myRepeater" runat="server">
<HeaderTemplate>
<table>
<tr>
<th>Document Name</th>
<th>URL Link</th>
</tr>
</HeaderTemplate>
<Itemtemplate>
<tr>
<td><%# Container.DataItem("fldDocName") %></td>
<td><A Href ="<%# Container.DataItem("fldDocLocation") %>"></A></td>
</tr>
</Itemtemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater></p>
</form>
</body>
</html>