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,vSurna me,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?tabi ndex=1&tabid=14&passid=[ % # DataBinder.Eval(Container.DataItem,"prid" ) % ]&possid=[ % # DataBinder.Eval(Container.DataItem,"posi d") %]'][IMG SRC="../images/lightpro.gif" border="0" vspace="0"][/a]
[/td]
[td height="25px" width="18%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Fore name") %]
[%# DataBinder.Eval(Container.DataItem,"Midd lename") %]
[%# DataBinder.Eval(Container.DataItem,"Surn ame") %]
[asp:label id="message" runat="server" /]
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"club name") %]
[/td]
[td height="25px" width="12%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"natc ountry") %]
[/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,"Heig htMtr") %]
[/td]
[td height="25px" width="6%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Heig htFI") %] Ft
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Cont ract", "{0:D}") %]
[/td]
[td height="25px" width="10%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"best ft") %]
[/td]
[td height="25px" width="30px" class="splight"]
[A href='/PortalVB/DesktopDefault.aspx?tabi ndex=1&tabid=14&passid=[%# DataBinder.Eval(Container.DataItem,"prid" ) %]&possid=[%# DataBinder.Eval(Container.DataItem,"posi d") %]'][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?tabi ndex=1&tabid=14&passid=[%# DataBinder.Eval(Container.DataItem,"prid" ) %]&possid=[%# DataBinder.Eval(Container.DataItem,"posi d") %]'][IMG SRC="../images/darkpro.gif" border="0" vspace="0"][/a]
[/td]
[td height="25px" width="18%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Fore name") %]
[%# DataBinder.Eval(Container.DataItem,"Midd lename") %]
[%# DataBinder.Eval(Container.DataItem,"Surn ame") %]
[asp:label id="message" runat="server" /]
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"club name") %]
[/td]
[td height="25px" width="12%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"natc ountry") %]
[/td]
[td height="25px" width="12%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Play erPos") %]
[/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,"Heig htFI") %] Ft
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Cont ract", "{0:D}") %]
[/td]
[td height="25px" width="10%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"best ft") %]
[/td]
[td height="25px" width="30px" class="spdark"]
[A href='/PortalVB/DesktopDefault.aspx?tabi ndex=1&tabid=14&passid=[%# DataBinder.Eval(Container.DataItem,"prid" ) %]&possid=[%# DataBinder.Eval(Container.DataItem,"posi d") %]'][IMG SRC="../images/Rightdacon.gif" border="0" vspace="0"][/a]
[/td]
[/tr]
[/table]
[/alternatingItemTemplate]
[/asp:DataList]
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,vSurna
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?tabi
[/td]
[td height="25px" width="18%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Fore
[%# DataBinder.Eval(Container.DataItem,"Midd
[%# DataBinder.Eval(Container.DataItem,"Surn
[asp:label id="message" runat="server" /]
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"club
[/td]
[td height="25px" width="12%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"natc
[/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,"Heig
[/td]
[td height="25px" width="6%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Heig
[/td]
[td height="25px" width="11%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"Cont
[/td]
[td height="25px" width="10%" class="splight"]
[%# DataBinder.Eval(Container.DataItem,"best
[/td]
[td height="25px" width="30px" class="splight"]
[A href='/PortalVB/DesktopDefault.aspx?tabi
[/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?tabi
[/td]
[td height="25px" width="18%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Fore
[%# DataBinder.Eval(Container.DataItem,"Midd
[%# DataBinder.Eval(Container.DataItem,"Surn
[asp:label id="message" runat="server" /]
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"club
[/td]
[td height="25px" width="12%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"natc
[/td]
[td height="25px" width="12%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Play
[/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,"Heig
[/td]
[td height="25px" width="11%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"Cont
[/td]
[td height="25px" width="10%" class="spdark"]
[%# DataBinder.Eval(Container.DataItem,"best
[/td]
[td height="25px" width="30px" class="spdark"]
[A href='/PortalVB/DesktopDefault.aspx?tabi
[/td]
[/tr]
[/table]
[/alternatingItemTemplate]
[/asp:DataList]
