How do you alternate images in a data bound column of a data grid control?

[C Newby]

I have a data grid control taht contains a data bound coulmn called "Type".
Depending on the value of "Type" I want to display a corresponding image in
the rendered table cell. So, if the value of type is 1, I want to show
image1.gif. If the value is 2, I want to show image2.gif. Is there an easy
way to do this?

TIA//

[Cowboy \(Gregory A. Beamer\)]

If SQL Server, you can do it in your statement:

, 'image'+imageTy pe+'.gif' As ImageName

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"C Newby" <ca*@democracyd ata.com> wrote in message
news:u8******** ******@tk2msftn gp13.phx.gbl...

I have a data grid control taht contains a data bound coulmn called "Type". Depending on the value of "Type" I want to display a corresponding image in the rendered table cell. So, if the value of type is 1, I want to show
image1.gif. If the value is 2, I want to show image2.gif. Is there an easy
way to do this?

TIA//

[C Newby]

Right, but i was hoping for something i could determine at run time. Any
thoughts on that? Thanks for your reply.

"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM> wrote in
message news:eU******** ******@TK2MSFTN GP11.phx.gbl...

If SQL Server, you can do it in your statement:

, 'image'+imageTy pe+'.gif' As ImageName

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"C Newby" <ca*@democracyd ata.com> wrote in message
news:u8******** ******@tk2msftn gp13.phx.gbl...

I have a data grid control taht contains a data bound coulmn called

"Type".

Depending on the value of "Type" I want to display a corresponding image

in

the rendered table cell. So, if the value of type is 1, I want to show
image1.gif. If the value is 2, I want to show image2.gif. Is there an easy way to do this?

TIA//

[Bill Borg]

You can also write a function in your databinding expression for the image cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage is an accessible method (e.g. page.getmyimage ), and parms is whatever you want to pass to get the image (the value of Type in this case)

----- C Newby wrote: ----

Right, but i was hoping for something i could determine at run time. An
thoughts on that? Thanks for your reply

"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM> wrote i
message news:eU******** ******@TK2MSFTN GP11.phx.gbl..

If SQL Server, you can do it in your statement

, 'image'+imageTy pe+'.gif' As ImageNam
--

Gregory A. Beame
MVP; MCP: +I, SE, SD, DB

*************** *************** *************** *************** *********

Think Outside the Box
*************** *************** *************** *************** *********
"C Newby" <ca*@democracyd ata.com> wrote in messag
news:u8******** ******@tk2msftn gp13.phx.gbl..

I have a data grid control taht contains a data bound coulmn calle

"Type"

Depending on the value of "Type" I want to display a corresponding imag

i

the rendered table cell. So, if the value of type is 1, I want to sho
image1.gif. If the value is 2, I want to show image2.gif. Is there a eas way to do this

TIA/
>>

[C Newby]

Ah gotcha...thanks Bill, that's what i was looking for.

"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in message
news:C6******** *************** ***********@mic rosoft.com...

You can also write a function in your databinding expression for the image cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage is
an accessible method (e.g. page.getmyimage ), and parms is whatever you want
to pass to get the image (the value of Type in this case).
----- C Newby wrote: -----

Right, but i was hoping for something i could determine at run time. Any thoughts on that? Thanks for your reply.

"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM> wrote in message news:eU******** ******@TK2MSFTN GP11.phx.gbl...

> If SQL Server, you can do it in your statement:

>> , 'image'+imageTy pe+'.gif' As ImageName
>> -- > Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA

>> *************** *************** *************** *************** **********

> Think Outside the Box!
> *************** *************** *************** *************** **********

> "C Newby" <ca*@democracyd ata.com> wrote in message
> news:u8******** ******@tk2msftn gp13.phx.gbl...

>> I have a data grid control taht contains a data bound coulmn

called > "Type".

>> Depending on the value of "Type" I want to display a corresponding

image > in

>> the rendered table cell. So, if the value of type is 1, I want to

show >> image1.gif. If the value is 2, I want to show image2.gif. Is there

an easy >> way to do this?
>>>> TIA//
>>>>>>

[C Newby]

Actually, that's not working for me. When the page renders, the table cell
just contains the expression. For example, i have something like:
<asp:BoundColum n DataField="Some thing" HeaderText="Som ething"
DataFormatStrin g="<%=getSometh ing({0})%>"></asp:BoundColumn >

which renders:
<td><%=getSomet hing( SomeType )%></td>

But I do have a protected member method of the code behind class called
getSomething( someType Type ){ return "something" ; }

Any thoughts?

thanks//
"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in message
news:C6******** *************** ***********@mic rosoft.com...

You can also write a function in your databinding expression for the image cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage is
an accessible method (e.g. page.getmyimage ), and parms is whatever you want
to pass to get the image (the value of Type in this case).
----- C Newby wrote: -----

Right, but i was hoping for something i could determine at run time. Any thoughts on that? Thanks for your reply.

"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM> wrote in message news:eU******** ******@TK2MSFTN GP11.phx.gbl...

> If SQL Server, you can do it in your statement:

>> , 'image'+imageTy pe+'.gif' As ImageName
>> -- > Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA

>> *************** *************** *************** *************** **********

> Think Outside the Box!
> *************** *************** *************** *************** **********

> "C Newby" <ca*@democracyd ata.com> wrote in message
> news:u8******** ******@tk2msftn gp13.phx.gbl...

>> I have a data grid control taht contains a data bound coulmn

called > "Type".

>> Depending on the value of "Type" I want to display a corresponding

image > in

>> the rendered table cell. So, if the value of type is 1, I want to

show >> image1.gif. If the value is 2, I want to show image2.gif. Is there

an easy >> way to do this?
>>>> TIA//
>>>>>>

[Bill Borg]

You need to use a template column, not a bound column, which you can create in the property builder in the idea, or straight in the html. Bound column is good for showing something that resolves to text (and the format string can format it for you), but you need a picture in this case. Try something like this, where GetMyPicture is your function that returns the filename of the image you want to show. In my case, I'm passing container.datai tem("cs_key"), which will resolve to the cs_key field in the datasource. In your case, for cs_key you'll use the column name of your type field

<asp:TemplateCo lumn HeaderText="My Picture Column"><itemte mplate><img src='<%# GetMyPicture(co ntainer.dataite m("cs_key")) %>'/> (don't forget the '#'
</itemtemplate></asp:TemplateCol umn

Regarding the protected function, that should be fine, but if at run-time it can't find it you'll get a semi-friendly message, something to the effect of "...GetMyPictur e is not declared...

hth

Bil

----- C Newby wrote: ----

Actually, that's not working for me. When the page renders, the table cel
just contains the expression. For example, i have something like
<asp:BoundColum n DataField="Some thing" HeaderText="Som ething
DataFormatStrin g="<%=getSometh ing({0})%>"></asp:BoundColumn

which renders
<td><%=getSomet hing( SomeType )%></td

But I do have a protected member method of the code behind class calle
getSomething( someType Type ){ return "something" ;

Any thoughts

thanks/
"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in messag
news:C6******** *************** ***********@mic rosoft.com..

You can also write a function in your databinding expression for the imag cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage i
an accessible method (e.g. page.getmyimage ), and parms is whatever you wan
to pass to get the image (the value of Type in this case)

----- C Newby wrote: ----
Right, but i was hoping for something i could determine at run time An thoughts on that? Thanks for your reply "Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM wrote i

message news:eU******** ******@TK2MSFTN GP11.phx.gbl..

If SQL Server, you can do it in your statement

, 'image'+imageTy pe+'.gif' As ImageNam
-- Gregory A. Beame
MVP; MCP: +I, SE, SD, DB
*************** *************** *************** *************** *********

Think Outside the Box

*************** *************** *************** *************** *********

"C Newby" <ca*@democracyd ata.com> wrote in messag
news:u8******** ******@tk2msftn gp13.phx.gbl..

I have a data grid control taht contains a data bound coulm

calle "Type"

Depending on the value of "Type" I want to display a correspondin

imag i

the rendered table cell. So, if the value of type is 1, I want t

sho image1.gif. If the value is 2, I want to show image2.gif. Is ther

a eas way to do this
> TIA/
>>>

[Bill Borg]

You need to use a template column, not a bound column, which you can create in the property builder in the idea, or straight in the html. Bound column is good for showing something that resolves to text (and the format string can format it for you), but you need a picture in this case. Try something like this, where GetMyPicture is your function that returns the filename of the image you want to show. In my case, I'm passing container.datai tem("cs_key"), which will resolve to the cs_key field in the datasource. In your case, for cs_key you'll use the column name of your type field

<asp:TemplateCo lumn HeaderText="My Picture Column"><itemte mplate><img src='<%# GetMyPicture(co ntainer.dataite m("cs_key")) %>'/> (don't forget the '#'
</itemtemplate></asp:TemplateCol umn

Regarding the protected function, that should be fine, but if at run-time it can't find it you'll get a semi-friendly message, something to the effect of "...GetMyPictur e is not declared...

hth

Bil

----- C Newby wrote: ----

Actually, that's not working for me. When the page renders, the table cel
just contains the expression. For example, i have something like
<asp:BoundColum n DataField="Some thing" HeaderText="Som ething
DataFormatStrin g="<%=getSometh ing({0})%>"></asp:BoundColumn

which renders
<td><%=getSomet hing( SomeType )%></td

But I do have a protected member method of the code behind class calle
getSomething( someType Type ){ return "something" ;

Any thoughts

thanks/
"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in messag
news:C6******** *************** ***********@mic rosoft.com..

You can also write a function in your databinding expression for the imag cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage i
an accessible method (e.g. page.getmyimage ), and parms is whatever you wan
to pass to get the image (the value of Type in this case)

----- C Newby wrote: ----
Right, but i was hoping for something i could determine at run time An thoughts on that? Thanks for your reply "Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM wrote i

message news:eU******** ******@TK2MSFTN GP11.phx.gbl..

If SQL Server, you can do it in your statement

, 'image'+imageTy pe+'.gif' As ImageNam
-- Gregory A. Beame
MVP; MCP: +I, SE, SD, DB
*************** *************** *************** *************** *********

Think Outside the Box

*************** *************** *************** *************** *********

"C Newby" <ca*@democracyd ata.com> wrote in messag
news:u8******** ******@tk2msftn gp13.phx.gbl..

I have a data grid control taht contains a data bound coulm

calle "Type"

Depending on the value of "Type" I want to display a correspondin

imag i

the rendered table cell. So, if the value of type is 1, I want t

sho image1.gif. If the value is 2, I want to show image2.gif. Is ther

a eas way to do this
> TIA/
>>>

[C Newby]

Thanks again Bill,

I was able to get it working this time. One thing though,
"container.data item("myField") " didn't work for me, I ended up using:
"DataBinder.Eva l(Container, "DataItem.myFie ld")". Any thoughts on that?

Hey again, I really apreciate the help//

"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in message
news:80******** *************** ***********@mic rosoft.com...

You need to use a template column, not a bound column, which you can create in the property builder in the idea, or straight in the html. Bound
column is good for showing something that resolves to text (and the format
string can format it for you), but you need a picture in this case. Try
something like this, where GetMyPicture is your function that returns the
filename of the image you want to show. In my case, I'm passing
container.datai tem("cs_key"), which will resolve to the cs_key field in the
datasource. In your case, for cs_key you'll use the column name of your
type field.
<asp:TemplateCo lumn HeaderText="My Picture Column"><itemte mplate><img src='<%# GetMyPicture(co ntainer.dataite m("cs_key")) %>'/> (don't forget the
'#') </itemtemplate></asp:TemplateCol umn>
Regarding the protected function, that should be fine, but if at run-time it can't find it you'll get a semi-friendly message, something to the effect
of "...GetMyPictur e is not declared..."
hth,

Bill

----- C Newby wrote: -----

Actually, that's not working for me. When the page renders, the table cell just contains the expression. For example, i have something like:
<asp:BoundColum n DataField="Some thing" HeaderText="Som ething"
DataFormatStrin g="<%=getSometh ing({0})%>"></asp:BoundColumn >

which renders:
<td><%=getSomet hing( SomeType )%></td>

But I do have a protected member method of the code behind class called getSomething( someType Type ){ return "something" ; }

Any thoughts?

thanks//
"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in message
news:C6******** *************** ***********@mic rosoft.com...

> You can also write a function in your databinding expression for the image

cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage is an accessible method (e.g. page.getmyimage ), and parms is whatever you want to pass to get the image (the value of Type in this case). >> ----- C Newby wrote: -----
>> Right, but i was hoping for something i could determine at run time.

Any

> thoughts on that? Thanks for your reply.

>>>> "Cowboy (Gregory A. Beamer)"

<No************ @comcast.netNoS pamM>

wrote in

> message news:eU******** ******@TK2MSFTN GP11.phx.gbl...

>> If SQL Server, you can do it in your statement:
>>> , 'image'+imageTy pe+'.gif' As ImageName
>>> --
>> Gregory A. Beamer
>> MVP; MCP: +I, SE, SD, DBA
>>>

*************** *************** *************** *************** ********** >> Think Outside the Box!
>>

*************** *************** *************** *************** **********

>> "C Newby" <ca*@democracyd ata.com> wrote in message
>> news:u8******** ******@tk2msftn gp13.phx.gbl...
>>> I have a data grid control taht contains a data bound coulmn called >> "Type".
>>> Depending on the value of "Type" I want to display a

corresponding image >> in
>>> the rendered table cell. So, if the value of type is 1, I want to show >>> image1.gif. If the value is 2, I want to show image2.gif. Is

there an

> easy

>>> way to do this?
>>>>> TIA//
>>>>>>>

[C Newby]

Thanks again Bill,

I was able to get it working this time. One thing though,
"container.data item("myField") " didn't work for me, I ended up using:
"DataBinder.Eva l(Container, "DataItem.myFie ld")". Any thoughts on that?

Hey again, I really apreciate the help//

"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in message
news:80******** *************** ***********@mic rosoft.com...

You need to use a template column, not a bound column, which you can create in the property builder in the idea, or straight in the html. Bound
column is good for showing something that resolves to text (and the format
string can format it for you), but you need a picture in this case. Try
something like this, where GetMyPicture is your function that returns the
filename of the image you want to show. In my case, I'm passing
container.datai tem("cs_key"), which will resolve to the cs_key field in the
datasource. In your case, for cs_key you'll use the column name of your
type field.
<asp:TemplateCo lumn HeaderText="My Picture Column"><itemte mplate><img src='<%# GetMyPicture(co ntainer.dataite m("cs_key")) %>'/> (don't forget the
'#') </itemtemplate></asp:TemplateCol umn>
Regarding the protected function, that should be fine, but if at run-time it can't find it you'll get a semi-friendly message, something to the effect
of "...GetMyPictur e is not declared..."
hth,

Bill

----- C Newby wrote: -----

Actually, that's not working for me. When the page renders, the table cell just contains the expression. For example, i have something like:
<asp:BoundColum n DataField="Some thing" HeaderText="Som ething"
DataFormatStrin g="<%=getSometh ing({0})%>"></asp:BoundColumn >

which renders:
<td><%=getSomet hing( SomeType )%></td>

But I do have a protected member method of the code behind class called getSomething( someType Type ){ return "something" ; }

Any thoughts?

thanks//
"Bill Borg" <an*******@disc ussions.microso ft.com> wrote in message
news:C6******** *************** ***********@mic rosoft.com...

> You can also write a function in your databinding expression for the image

cell, e.g. imageurl (or src)=<%# GetMyImage(parm s) %>, where GetMyImage is an accessible method (e.g. page.getmyimage ), and parms is whatever you want to pass to get the image (the value of Type in this case). >> ----- C Newby wrote: -----
>> Right, but i was hoping for something i could determine at run time.

Any

> thoughts on that? Thanks for your reply.

>>>> "Cowboy (Gregory A. Beamer)"

<No************ @comcast.netNoS pamM>

wrote in

> message news:eU******** ******@TK2MSFTN GP11.phx.gbl...

>> If SQL Server, you can do it in your statement:
>>> , 'image'+imageTy pe+'.gif' As ImageName
>>> --
>> Gregory A. Beamer
>> MVP; MCP: +I, SE, SD, DBA
>>>

*************** *************** *************** *************** ********** >> Think Outside the Box!
>>

*************** *************** *************** *************** **********

>> "C Newby" <ca*@democracyd ata.com> wrote in message
>> news:u8******** ******@tk2msftn gp13.phx.gbl...
>>> I have a data grid control taht contains a data bound coulmn called >> "Type".
>>> Depending on the value of "Type" I want to display a

corresponding image >> in
>>> the rendered table cell. So, if the value of type is 1, I want to show >>> image1.gif. If the value is 2, I want to show image2.gif. Is

there an

> easy

>>> way to do this?
>>>>> TIA//
>>>>>>>