Open different page based on database column value using ASP.Net Repeater

Hi qasimshahzaduae1,

Please refer below sample code.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Here in this example i have used Employees table.

HTML

Default

<asp:Repeater ID="mainpageCards" runat="server">
    <ItemTemplate>
        <a style="text-decoration: none;"
                href='<%# If(Eval("Country").ToString() = "UK", String.Format("jobdetail.aspx?EmployeeID={0}",Eval("EmployeeId")), String.Format("walkindetail.aspx?EmployeeID={0}",Eval("EmployeeId")))%>'
            <div id="wb_Card1" class="card">
                <div id="Card1-card-body">
                    <%--<div style="overflow: hidden">
                        <img class="Card1-card-item0" id="imageshowID" src='<%#String.Concat("jobimages/", Eval("jobimage")) %>'
                            width="292" height="219" alt="" title="" runat="server" />
                    </div>--%>
                    <div id="Card1-card-item1">
                        <%#Eval("FirstName")%></div>
                    <div id="Card1-card-item2">
                        <%#Eval("LastName")%></div>
                    <div id="Card1-card-item3">
                        <i class="access-time-filled"></i>
                        <%#Eval("Title")%></div>
                    <div id="Card1-card-item4">
                        <i class="location-on"></i>Country:
                        <%#Eval("Country")%>
                        </div>
                </div>
            </div>
        </a>
    </ItemTemplate>
</asp:Repeater>

jobdetail

Employee Id: <asp:Label ID="lblId" runat="server"></asp:Label>

walkindetail

Employee Id: <asp:Label ID="lblId" runat="server" ></asp:Label>

Namespaces

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Code

Default

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Me.maincards()
    End If
End Sub

Private Sub maincards()
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim con As SqlConnection = New SqlConnection(constr)
    If con.State = ConnectionState.Closed Then
        con.Open()
    End If
    Dim Query As String = "SELECT EmployeeID, FirstName, LastName, Title, Country FROM Employees ORDER BY EmployeeID DESC"
    Dim cmd As New SqlCommand(Query, con)
    Dim Sdr As SqlDataReader = cmd.ExecuteReader()

    ' Bind the merged data to the repeater
    mainpageCards.DataSource = Sdr
    mainpageCards.DataBind()
    con.Close()
End Sub

jobdetail

Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
    lblId.Text = Request.QueryString("EmployeeID")
End Sub

walkindetail

Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
    lblId.Text = Request.QueryString("EmployeeID")
End Sub

Screenshot