"Nathan Sokalski" <njsokalski@hotmail.com> wrote in message
news:uNdcti34HHA.5852@TK2MSFTNGP02.phx.gbl...
>I have two fields in the Datatable that I am using as my DataSource that I
>need to multiply together before displaying them. Here is the databinding
>expressions from my ASPX file to display the fields separately:
>
> '<%# Databinder.Eval(Container.DataItem,"price","{0:C}") %>'
> '<%# Databinder.Eval(Container.DataItem,"quantity","{0:D}") %>'
>
> These are obviously both numeric values, but because my DataTable is not
> created from a database, I cannot add an extra field by modifying my SQL
> statement. Is there a way to somehow include an expression in the
> databinding expression that multiplies the two values together? The only
> alternative that I can think of is to use the ItemDataBound event and
> manually assign the product of the two values to the desired control, but
> because this requires using CType and FindControl, it is rather
> inefficient. Any other ideas? Thanks.
> --
> Nathan Sokalski
> njsokalski@hotmail.com
> http://www.nathansokalski.com/
>

"Alvin Bruney [MVP]" <some guy without an email address> wrote in message
news:ez7QMj44HHA.5724@TK2MSFTNGP05.phx.gbl...
> Why post this to so many groups, it's not necessary at all. In any case,
> you will need CType, you won't necessarily need FindControl. If you know
> the column, you can use the appropriate index to the cell.
>
> --
> Regards,
> Alvin Bruney
> ------------------------------------------------------
> Shameless author plug
> Excel Services for .NET - MS Press
> Professional VSTO 2005 - Wrox/Wiley
> OWC Black Book www.lulu.com/owc
>
> "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message
> news:uNdcti34HHA.5852@TK2MSFTNGP02.phx.gbl...
>>I have two fields in the Datatable that I am using as my DataSource that I
>>need to multiply together before displaying them. Here is the databinding
>>expressions from my ASPX file to display the fields separately:
>>
>> '<%# Databinder.Eval(Container.DataItem,"price","{0:C}") %>'
>> '<%# Databinder.Eval(Container.DataItem,"quantity","{0:D}") %>'
>>
>> These are obviously both numeric values, but because my DataTable is not
>> created from a database, I cannot add an extra field by modifying my SQL
>> statement. Is there a way to somehow include an expression in the
>> databinding expression that multiplies the two values together? The only
>> alternative that I can think of is to use the ItemDataBound event and
>> manually assign the product of the two values to the desired control, but
>> because this requires using CType and FindControl, it is rather
>> inefficient. Any other ideas? Thanks.
>> --
>> Nathan Sokalski
>> njsokalski@hotmail.com
>> http://www.nathansokalski.com/
>>
>
>

"ca8msm@aspnetlibrary.com" <mark.david.smith@gmail.com> wrote in message
news:1187687687.952550.63790@k79g2000hse.googlegroups.com...
> How do you create your DataTable? It would seem easier to me to just
> create another column at the same time and add both the values
> together.
>

"Nathan Sokalski" <njsokalski@hotmail.com> wrote in message
news:%23GNMTZF5HHA.2108@TK2MSFTNGP02.phx.gbl...
>I create my DataTable manually by adding DataColumns to a DataTable and
>then adding data using the DataTable's Rows.Add method. The reason I would
>prefer not to create an extra column is because I have to store the
>DataTable in ViewState, which, even though I will rarely have more than
>about 10 or so records in the DataTable, it can increase the size of the
>client's download, as well as require me to update more fields. If I could
>do the multiplication inline, it would allow me to have only one extra area
>in my code that is different, and would not increase the size of the
>client's download.
> --
> Nathan Sokalski
> njsokalski@hotmail.com
> http://www.nathansokalski.com/
>
> "ca8msm@aspnetlibrary.com" <mark.david.smith@gmail.com> wrote in message
> news:1187687687.952550.63790@k79g2000hse.googlegroups.com...
>> How do you create your DataTable? It would seem easier to me to just
>> create another column at the same time and add both the values
>> together.
>>
>
>