Here I will show you how to
bind one field data as a link in repeater control and its related data will be
shown in a gridview control.
Program
Default.aspx
code
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled
Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Repeater id="Repeater1" runat="server">
<HeaderTemplate>
<b>StudentDetails</b>
</HeaderTemplate>
<ItemTemplate>
<br>
<a href='<%#string.format("Default2.aspx?id={0}",container.dataitem("sid"))%>'>
<%#container.dataitem("sid")%>
</a>
</ItemTemplate>
<FooterTemplate>
<br>
<b>Completed</b>
</FooterTemplate>
</asp:Repeater>
</div>
</form>
</body>
</html>
Default.aspx.vb code
Imports
System.Data.SqlClient
Imports
System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Dim strConnString As String =
System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
Dim sqlda As
SqlDataAdapter
Dim com As
SqlCommand
Dim ds As
DataSet
Dim dt As
DataTable
Dim str As String
Dim con As New SqlConnection(strConnString)
Protected Sub
Page_Load(ByVal sender
As Object, ByVal
e As System.EventArgs)
Handles Me.Load
If Not
IsPostBack Then
con.Open()
str =
"select * from student"
com =
New SqlCommand(str, con)
sqlda =
New SqlDataAdapter(com)
ds =
New DataSet
sqlda.Fill(ds,
"student")
Repeater1.DataMember = "student"
Repeater1.DataSource = ds
Repeater1.DataBind()
con.Close()
End If
End Sub
End Class
Default2.aspx
code
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled
Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:GridView ID="GridView1" BackColor="#FF9999" runat="server">
<HeaderStyle BackColor="#FFCC99" />
</asp:GridView>
</form>
</body>
</html>
Default2.aspx.vb code
Imports
System.Data.SqlClient
Imports
System.Data
Partial Class Default2
Inherits System.Web.UI.Page
Dim strConnString As String =
System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
Dim sqlda As
SqlDataAdapter
Dim com As
SqlCommand
Dim ds As
DataSet
Dim dt As
DataTable
Dim str As String
Dim con As New SqlConnection(strConnString)
Protected Sub
Page_Load(ByVal sender
As Object, ByVal
e As System.EventArgs)
Handles Me.Load
If Not
IsPostBack Then
con.Open()
str =
"select * from student where sid='" &
Request.QueryString("id") &
"'"
com =
New SqlCommand(str, con)
sqlda =
New SqlDataAdapter(com)
ds =
New DataSet
ds.Clear()
ds.Reset()
sqlda.Fill(ds,
"student")
GridView1.DataMember = "student"
GridView1.DataSource = ds
GridView1.DataBind()
con.Close()
End If
End Sub
End Class
Output
