image hide or show in repeater from database table.
table field name is status.
<asp:Repeater ID="similarRepeater" runat="server">
<ItemTemplate>
<div id="wb_similarprofilescard">
<a style="text-decoration:none; " href="Memberprofile?ProfileID=<%#Eval("ProfileID")%>">
<div id="similarprofilescard-card-body">
<img id="similarprofilescard-card-item0" src="Membersphoto/<%#Eval("userimage")%>" alt="" title="">
<div id="similarprofilescard-card-item1"><%#Eval("Username")%></div>
<div id="similarprofilescard-card-item2"><%#Eval("age")%> Years | <%#Eval("heightft")%> <%#Eval("heightinc")%> | <%#Eval("Face")%></div>
<div id="similarprofilescard-card-item3"><%#Eval("religion")%> | <%#Eval("cast")%></div>
<div id="similarprofilescard-card-item4">Looking Partner <%#Eval("agefrom")%> To <%#Eval("ageto")%></div>
<div id="similarprofilescard-card-item5"><%#Eval("prescity")%> | <%#Eval("prescountry")%></div>
<div id="similarprofilescard-card-item6"><%#Eval("education")%> | <%#Eval("userwork")%></div>
</div>
</a>
</div>
</ItemTemplate>
</asp:Repeater>
Private Sub similardata()
Dim constr As String = ConfigurationManager.ConnectionStrings("Constring").ConnectionString
Dim con As SqlConnection = New SqlConnection(constr)
If con.State = ConnectionState.Closed Then
con.Open()
End If
If Lblgenderreapter.Text = "Male" Then
Dim Query = "SELECT dbo.Tbl_Personalinfo.age, dbo.Tbl_Personalinfo.religion, dbo.Tbl_Personalinfo.cast, dbo.Tbl_Personalinfo.heightft, dbo.Tbl_Personalinfo.heightinc, dbo.Tbl_Personalinfo.ProfileID, dbo.Tbl_userimage.userimage, dbo.Tbl_Personalinfo.Username, dbo.Tbl_partnerpreff.agefrom, dbo.Tbl_partnerpreff.ageto, dbo.Tbl_education.userwork, dbo.Tbl_education.education, dbo.Tbl_Personalinfo.gender, dbo.Tbl_Personalinfo.face, dbo.Tbl_Personalinfo.profilestatus, dbo.Tbl_address.prescity, dbo.Tbl_address.prescountry FROM dbo.Tbl_userimage INNER JOIN dbo.Tbl_Personalinfo ON dbo.Tbl_userimage.ProfileID = dbo.Tbl_Personalinfo.ProfileID INNER JOIN dbo.Tbl_education ON dbo.Tbl_Personalinfo.ProfileID = dbo.Tbl_education.ProfileID INNER JOIN dbo.Tbl_partnerpreff ON dbo.Tbl_education.ProfileID = dbo.Tbl_partnerpreff.ProfileID INNER JOIN dbo.Tbl_address ON dbo.Tbl_userimage.ProfileID = dbo.Tbl_address.ProfileID where dbo.Tbl_Personalinfo.gender='Female' and Tbl_Personalinfo.profilestatus='Verified'"
Dim cmd As New SqlCommand(Query, con)
Dim Sdr As SqlDataReader = cmd.ExecuteReader()
similarRepeater.DataSource = Sdr
similarRepeater.DataBind()
con.Close()
Profileiddisplaylbl.Text = Session("login").ToString()
ElseIf Lblgenderreapter.Text = "Female" Then
Dim Query = "SELECT dbo.Tbl_Personalinfo.age, dbo.Tbl_Personalinfo.religion, dbo.Tbl_Personalinfo.cast, dbo.Tbl_Personalinfo.heightft, dbo.Tbl_Personalinfo.heightinc, dbo.Tbl_Personalinfo.ProfileID, dbo.Tbl_userimage.userimage, dbo.Tbl_Personalinfo.Username, dbo.Tbl_partnerpreff.agefrom, dbo.Tbl_partnerpreff.ageto, dbo.Tbl_education.userwork, dbo.Tbl_education.education, dbo.Tbl_Personalinfo.gender, dbo.Tbl_Personalinfo.face, dbo.Tbl_Personalinfo.profilestatus, dbo.Tbl_address.prescity, dbo.Tbl_address.prescountry FROM dbo.Tbl_userimage INNER JOIN dbo.Tbl_Personalinfo ON dbo.Tbl_userimage.ProfileID = dbo.Tbl_Personalinfo.ProfileID INNER JOIN dbo.Tbl_education ON dbo.Tbl_Personalinfo.ProfileID = dbo.Tbl_education.ProfileID INNER JOIN dbo.Tbl_partnerpreff ON dbo.Tbl_education.ProfileID = dbo.Tbl_partnerpreff.ProfileID INNER JOIN dbo.Tbl_address ON dbo.Tbl_userimage.ProfileID = dbo.Tbl_address.ProfileID where dbo.Tbl_Personalinfo.gender='Male' and Tbl_Personalinfo.profilestatus='Verified'"
Dim cmd As New SqlCommand(Query, con)
Dim Sdr As SqlDataReader = cmd.ExecuteReader()
similarRepeater.DataSource = Sdr
similarRepeater.DataBind()
con.Close()
Profileiddisplaylbl.Text = Session("login").ToString()
End If
End Sub
