.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Repeater control link data is clicked then corresponding values will be shown in Gridview

Posted By:satyapriyanayak       Posted Date: April 16, 2013    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

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
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

    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



     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend