GridView last row

[Bakedgoods]

ASP.net GridView last row

I'm trying to access the last row of my GridView but i'm not sure how to do it?

I have some totals in the last row of each column (NOT THE FOOTER) and I want to create an if statement that will change the colour .

The thing is, the totals are done in SQL, so there's no binding to any form of control (Label etc), so I don't know how to go about setting the colours, if that makes any sense?

 

[Shadez]

need more info to help

which grid view are you using
what language are you using

if you are using the vb.net and a datagridview then you would do it something like this.

Dim adatagridviewcell As DataGridViewCell = aDataGridView.Item(somecolumn, aDataGridView.RowCount)

adatagridviewcell.Style.BackColor = Color.Crimson

 

[Bakedgoods]

Apologies, ASP.net and VB.

I understand i'll have to do some kind of count, but how do I format only the final row?

 

[Dj_Jestar]

Isn't that exactly what has just been demonstrated to you?

 

[Bakedgoods]

I thought it would be Rows -1 though?

 

[Dj_Jestar]

Not touchy. It was merely a question.

Possibly.. try it.

 

[Shadez]

Touchy.

I thought it would be Rows -1 though?

could be rows -1 would have to try it to find out.

 

[Bakedgoods]

Dim adatagridviewcell As DataGridViewCell = aDataGridView.Item(somecolumn, aDataGridView.RowCount)

adatagridviewcell.Style.BackColor = Color.Crimson

DataGridViewCell isn't defined.

Still no luck with this. I know how to set the entire last row a colour, but I need to set the inidivdual cells based on an If statement.

LoggedHoursGridView.Rows(LoggedHoursGridView.Rows.Count - 1).BackColor = System.Drawing.Color.Red

That sets the final row background colour to red, but I can't workout how to do each cell.

 

[MonkieMann]

int cellNumber = 4;

LoggedHoursGridView.Rows(LoggedHoursGridView.Rows.Count - 1).Cells[cellNumber].BackColor = System.Drawing.Color.Red

try that, i think thats how i'd do it in C# anyways