I understand how to connect a SqlDataSource to a GridView and have a nice 
data-connected, paginated web page generated with virtually no coding. 
Starting from that base, I would like to add an extra column to the GridView 
and do two things: for each row, based on the value of another column, insert 
a string in the new column cell and set the background color of the new 
column cell. Suggested approaches would be appreciated.

Hi Michael,
you can create handler for RowDataBound event of your GridView. In this 
handler you will be able to access and modify cells and data of your current 
row.

protected void myGridView_OnRowDataBound(object sender, GridViewRowEventArgs 
e)
{
  if (e.Row.RowType = DataGridRowType.DataRow)
  {
    // e.Row.Cells contains collection of server side td elements, you can 
fill
   // text property or work with collection of controls inside this element
    e.Row.Cells[INDEX_OF_YOUR_COLUMN].Text = EvalMyField(e.Row.DataItem ); 
// DataItem contains source of data for this row, it is object used by data 
source to fill your row
    // you can also modify css style for your elelment
    e.Row.Cells[INDEX_OF_YOUR_COLUMN].Attributes.Add("style", ".......");
  }
} 

Regards,
Ladislav

"michael sorens" wrote:


> I understand how to connect a SqlDataSource to a GridView and have a nice 
> data-connected, paginated web page generated with virtually no coding. 
> Starting from that base, I would like to add an extra column to the GridView 
> and do two things: for each row, based on the value of another column, insert 
> a string in the new column cell and set the background color of the new 
> column cell. Suggested approaches would be appreciated.

Splendid! I had to test for DataControlRowType.DataRow rather than 
DataGridRowType.DataRow, but that essentially did most of what I needed.

Now how do I position the new column as the right-most column?
I first tried adding a new column of type Template in the visual designer. 
This new column became the first column. I tried the same thing 
programmatically by calling gridView.Columns.Add() in the PageLoad handler 
and it also became the first column. I then switched to Columns.Insert() but 
in the PageLoad handler the binding has not yet occurred, hence column count 
is still 0. When the binding occurs, the columns are added to the right, 
again leaving my new column as the left-most. What event handler would give 
me access to the GridView after the columns have been loaded so I can then 
add my new column where I want?

Hi Michael,

I'm glad that you've solved your first issue.

For the second question, have you tried to add the column in GridView's 
DataBound event? In this event, the data has been bound and those columns 
are generated, therefore you can add your column to the right-most.

Please let me know the result. Thanks.


Regards,
Walter Wang (wawang@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.