I have a datalist:
<asp:DataList ID="DataList2" runat="server"
DataSourceID="ObjectDataSource2"
RepeatDirection=Horizontal
RepeatColumns=4 EnableViewState="False" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center">
<ItemTemplate>
<DIV class=picFrame>
<asp:HyperLink runat="server" NavigateUrl='<%# DataBinder.Eval(Container.DataItem, "UserID", "profile.aspx?uid={0}") %>' >
<IMG alt="<%# DataBinder.Eval(Container.DataItem, "Firstname") %>" src="userimages/<%# PickUserGender(DataBinder.Eval(Container.DataItem, "UserPic"),DataBinder.Eval(Container.DataItem, "UserID")) %>" width="80px" height="80px" border=0>
<BR><%# Eval("firstname") %></SPAN>(<%#Eval("friendscount")%>)</asp:HyperLink>
<br /><%# isOnline(DataBinder.Eval(Container.DataItem, "userid")) %></div>
</ItemTemplate>
</asp:DataList>
here is the
vb class code:
Public Shared Function PickUserGender(ByVal UserPic As Object, ByVal UserID As Object) As String
Dim Pic As String
If IsDBNull(UserPic) Or UserPic = String.Empty Then
Dim strSQl As String
Dim dr As SqlDataReader
Dim cmd As New SqlCommand
Dim Conn As New SqlConnection
strSQl = "SELECT UserID,UserPic,Gender FROM Users userid=" & UserID
Conn = New SqlConnection(ConfigurationManager.ConnectionStrin gs("Conn").ConnectionString)
cmd = New SqlCommand(strSQl, Conn)
Conn.Open()
dr = cmd.ExecuteReader()
dr.Read()
If dr.HasRows Then
If dr("gender") = "male" Then
Pic = "noimage_male.jpg"
Return Pic
Else
Pic = "noimage_female.jpg"
Return Pic
End If
End If
dr.Close()
Else
Pic = UserPic
Return Pic
End If
End Function
i get this error:
System.Data.SqlClient.SqlException: Incorrect syntax near '='.
function returns Incorrect syntax
