Hello,
I am trying to make a datagrid list the Headlines of Jokes from my database. When the user clicks on a link they would get transported to another PAge(detailedpage.aspx) to see the joke Headline and Joke Text. Here is how I've done it so far. However, something is missing as it does not work. I am not familiar with Codebehind. I think that may be it. Could someone please advise as to what I need to do here.
thanks,
Ray
jokepage.aspx
<%@ Page Language="
vb" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
Sub Page_load(Sender as object, e as EventArgs)
Dim objConnection As OleDbConnection
DIm objCommand As OleDbDataAdapter
Dim strConnect As String
Dim strCommand AS string
Dim Dataset1 As New DataSet
strConnect="Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect+="Data Source=C:\BegASPNet11\jokesdata.mdb;"
strConnect+="Persist Security Info=False"
strCommand = "SELECT JokeHeadline, jokeText FROM jokes"
objConnection = New OleDbConnection (strConnect)
objCommand = New OleDbDataAdapter (strCommand, objConnection)
objCommand.Fill(DataSet1, "jokes")
DataGrid1.DataSource=DataSet1.Tables("jokes").Defa ultview
DataGrid1.Databind()
end sub
</script>
<html>
<head>
<title>Datagrid Control Example</title>
</head>
<body>
<asp:DataGrid id="DataGrid1" runat="server"
AutoGenerateColumns="False" width="650px"
bordercolor="#6699cc" borderwidth="1"
cellpadding="4" font-Name="Verdana"
font-size="10pt"
headerStyle-BackColor="#6699cc">
<HeaderStyle backcolor="#6699CC"></HeaderStyle>
<Columns>
<asp:TemplateColumn>
<Itemtemplate>
<asp:Hyperlink runat=âserverâ Text =âJoke Headlines. Click to view Jokeâ
navigateUrl=â<%# detailedpage.aspx?JokeHeadline=â & _
Container.DataItem(âJokeHeadlineâ) & _
â&JokeText=â & Container.DataItem(âJokeTextâ) %>â />
</itemtemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
<br />
</body>
</html>
detailedpage.aspx
<%@ Page Language="
vb" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
lbl1.text=Request.QueryString[âcJokeHeadlineâ].ToString()
lbl2.text=Request.QueryString[âcJokeTextâ].ToString()
</script>
<asp:label name=âlbl1â runat=âserverâ />
<br/>
<asp:label name=âlbl2â runat=âserverâ />
Creating a hyperlink with multiple values
