Calculating Fields in an ASP Table using VB.Net

[coleenholley]

Ok, after all the research on datagrids, I've found that they won't really work for what I'm trying to do...I have a table that I need to have three columns as static data (but each row has a different value) and two other columns that have to do calculations, and a summary row/footer at the bottom of the table.

I guess maybe I'm stupid, because even with the help and information I've been given, how to populate each static column with different data in each row - I don't get! So, I've gone back to an ASP Table that I can hard-code the columns with the static data and do the calculations. My question is, does anyone have an easy way to do my calculation columns and footer in the table? TIA

Coleen


---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/

[Cor]

Re: Calculating Fields in an ASP Table using VB.Net

Hi Coleen

I think you just have to think this over.

In a normal table is a calculation and footer row in my opinion only
something that is put on the page after normal calculations, maybe only some
other design but that is than normal HTML and maybe CSS,

Or am I seeing something wrong?

Cor[color=blue]
> Ok, after all the research on datagrids, I've found that they won't really[/color]
work for what I'm trying to do...I have a table that I need to have three
columns as static data (but each row has a different value) and two other
columns that have to do calculations, and a summary row/footer at the bottom
of the table.[color=blue]
>
> I guess maybe I'm stupid, because even with the help and information I've[/color]
been given, how to populate each static column with different data in each
row - I don't get! So, I've gone back to an ASP Table that I can hard-code
the columns with the static data and do the calculations. My question is,
does anyone have an easy way to do my calculation columns and footer in the
table? TIA

[coleenholley]

re: Re: Calculating Fields in an ASP Table using VB.Net

Thanks Cor - I need to do calculations in three Columns AND in the footer. I know this probably won't turn out but here is what I need:

Column1 Column2 Column3 Column4 Column5 Column5
Data Data Data Calc Data Calc
in this Data Data Calc Data Calc
Column Data Data Calc Data Calc
is hard Data Data Calc Data Calc
coded Data Data Calc Data Calc
and Data Data Calc Data Calc
different Data Data Calc Data Calc

Totals Sum Sum Sum Sum Sum

I need to do calculations in at least two columns AND a Footer. I think this could be done in a datagrid, but I don't know how to hard code Column1 - This column has different data for each row HARD coded. Ugh! Any suggestions? There's a lot going on in this table, it's all read only (for THIS table) so I was hoping to use a datagird. Thanks for any/all help :-) Coleen

---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/

[Cor]

Re: Re: Calculating Fields in an ASP Table using VB.Net

Hi Colleen,

You said you did research on the datagrid,

Why are you not building your own datatable I think that will work, it is
not that hard to do
I type it here roughy
\\\
dim dt as new datatabel("Cole en")
dim dc1 as new datacolomn("Col umn1")
dt.columns.add( dc1)
dim dc2 as new datacolomn("Col umn2")
dt.columns.add( dc2)
till 5 than you can fill the table with all you want (but have a look at
datacolumn you can do more)


If you did this you can do to file a field as second item in the third row
dt.rows(2).item ("Column2) =mydata or text
or just as I do
dt.rows(2)(1) = mydata or text
And than
datagrid1.datas ource = dt
etc.
////

I hope this helps?

Cor
[color=blue]
> Thanks Cor - I need to do calculations in three Columns AND in the footer.[/color]
I know this probably won't turn out but here is what I need:[color=blue]
> Column1 Column2 Column3 Column4 Column5 Column5
> Data Data Data Calc Data Calc
> in this Data Data Calc Data Calc
> Column Data Data Calc Data Calc
> is hard Data Data Calc Data Calc
> coded Data Data Calc Data Calc
> and Data Data Calc Data Calc
> different Data Data Calc Data Calc
>
> Totals Sum Sum Sum Sum Sum
>
> I need to do calculations in at least two columns AND a Footer. I think[/color]
this could be done in a datagrid, but I don't know how to hard code
Column1 - This column has different data for each row HARD coded. Ugh! Any
suggestions? There's a lot going on in this table, it's all read only (for
THIS table) so I was hoping to use a datagird. Thanks for any/all help :-)
Coleen[color=blue]
>[/color]

[coleenholley]

re: Re: Re: Calculating Fields in an ASP Table using VB.Net

Hi Cor :-

Actually, I did create a complete ASP Table...I just found that I will need to do my calculations all the way down for two columns and still have to create a sum total in the footer. If I do the table, then I have a LOT of code to get each column(0).row(0 ) and so on for everycolumn and row in the table. I like your suggestion, if I understand it correctly, instead of giving the value of the variable for the columns, I give it a text value and hard code it? Thanks - I will try that tommorrow when I get back to my office. Thanks a lot for your help :-

Coleen

---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/