Image

Imagefuzzygoth wrote in Imagewebdev

Returning a Single variable for manipulation

I am returning the details of a search query from a stored procedure through a
datalist. I however need to pull out the value of the full profile column from however
many records are returned and check the value to see if its a full profile or a standard
profile so i can determine if its a full profile i can place an image button next to record
or just a place holding image if its a standard profile.

I need to work out how to do this as its the only obstacle left for me finnishing my
project :(

The code below is what is pulling the data from the sproc

and below that is the datalist that writes the information in the presentation code.



In the Code Section Between the code tags
Dim SearchInit As New ASPNetPortal.SearchPF()

' bind all portal users to Table
HeadMess.DataSource = SearchInit.SearchEngine(vForename,vSurname,vPosition,vContract,vAge,vHeight)
HeadMess.DataBind()



In the presentation Code section

[ asp:label id="title" runat="server" / ]
[ asp:DataList id="HeadMess" border="0" CellPadding="0" Width="100%" EnableViewState="false" runat="server" ]
[ ItemTemplate ]
[ table height="25px" cellpadding="0" cellspacing="0" border="0" ]
[ tr height="25px" ]
[ td height="25px" width="30px" class="splight" ]
[ A href='/PortalVB/DesktopDefault.aspx?tabindex=1&tabid=14&passid=[ % # DataBinder.Eval(Container.DataItem,"prid") % ]&possid=[ % # DataBinder.Eval(Container.DataItem,"posid") %]'][IMG SRC="../images/lightpro.gif" border="0" vspace="0"][/a]
[/td]
[td height="25px" width="18%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Forename") %] 
[%# DataBinder.Eval(Container.DataItem,"Middlename") %] 
[%# DataBinder.Eval(Container.DataItem,"Surname") %]
[asp:label id="message" runat="server" /]
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"clubname") %]
[/td]
[td height="25px" width="12%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"natcountry") %]
[/td]
[td height="25px" width="12%" class="splight"]
[%# DataBinder.Eval(Container.DataItem, "PlayerPos") %]
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem, "DoB", "{0:D}") %]
[/td]
[td height="25px" width="5%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"HeightMtr") %]
[/td]
[td height="25px" width="6%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"HeightFI") %] Ft
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Contract", "{0:D}") %]
[/td]
[td height="25px" width="10%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"bestft") %]
[/td]
[td height="25px" width="30px" class="splight"]
[A href='/PortalVB/DesktopDefault.aspx?tabindex=1&tabid=14&passid=[%# DataBinder.Eval(Container.DataItem,"prid") %]&possid=[%# DataBinder.Eval(Container.DataItem,"posid") %]'][IMG SRC="../images/Rightlicon.gif" border="0" vspace="0"][/a]
[/td]
[/tr]
[/table]
[/ItemTemplate]
[alternatingitemstyle forecolor="#000000" /]

[separatortemplate]
[/separatortemplate]

[alternatingItemTemplate]
[table height="25px" cellpadding="0" cellspacing="0" border="0"]
[tr]
[td height="25px" width="30px" class="spdark"]
[A href='/PortalVB/DesktopDefault.aspx?tabindex=1&tabid=14&passid=[%# DataBinder.Eval(Container.DataItem,"prid") %]&possid=[%# DataBinder.Eval(Container.DataItem,"posid") %]'][IMG SRC="../images/darkpro.gif" border="0" vspace="0"][/a]
[/td]
[td height="25px" width="18%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Forename") %] 
[%# DataBinder.Eval(Container.DataItem,"Middlename") %] 
[%# DataBinder.Eval(Container.DataItem,"Surname") %]
[asp:label id="message" runat="server" /]
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"clubname") %]
[/td]
[td height="25px" width="12%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"natcountry") %]
[/td]
[td height="25px" width="12%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"PlayerPos") %]
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem, "DoB", "{0:D}") %]
[/td]
[td height="25px" width="5%" class="spdark"]


[/td]
[td height="25px" width="6%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"HeightFI") %] Ft
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Contract", "{0:D}") %]
[/td]
[td height="25px" width="10%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"bestft") %]
[/td]
[td height="25px" width="30px" class="spdark"]
[A href='/PortalVB/DesktopDefault.aspx?tabindex=1&tabid=14&passid=[%# DataBinder.Eval(Container.DataItem,"prid") %]&possid=[%# DataBinder.Eval(Container.DataItem,"posid") %]'][IMG SRC="../images/Rightdacon.gif" border="0" vspace="0"][/a]
[/td]
[/tr]
[/table]
[/alternatingItemTemplate]
[/asp:DataList]