change color of row in a Datagrid view.

[kjqua]

Hi all,

I am newbie in c# and i have a question regarding DataGridView
I have a Table with 3 Columns
(0)IdLeggiSeria le <Is Primary key>
(1)ValoreSerial e <Is Integer>
(2)DataAcquisiz ione <Is DateTime>
I will like to change the color of each row that
in the in column(1) "ValoreSeri ale" the Value is greater than 50.
private void dataGridView1_C ellFormatting(o bject sender,
DataGridViewCel lFormattingEven tArgs e)
{

if
(dataGridView1. Columns[e.ColumnIndex].Name.Equals("V aloreSeriale"))
{
Int32 intValue;
if (Int32.TryParse ((String)e.Valu e, out intValue) &&
(intValue 50))
{
e.CellStyle.Bac kColor = Color.Yellow;
e.CellStyle.Sel ectionBackColor = Color.DarkRed;
}
}
}

In the Above code i only change the color a singular cell.

How can i change all the row.

Thanks
Marco

[Puja]

hi

u could use below function and call this function OnRowCreated=Hi ghlightRow
in your grid view

protected void HighlightRow(Ob ject sender, GridViewRowEven tArgs e)

{

if (e.Row.RowType == DataControlRowT ype.DataRow)

{

//find your control here whether its a textbox or label

Label lblValoreSerial e= (Label)e.Row.Fi ndControl("lblV aloreSeriale");

if(lblValorSeri ale != null)

{

ifConvert.ToInt 32((lblValoreSe riale.Text) 50)

e.Row.BackColor = System.Drawing. Color.Aqua;

}

}

}

hope this helps
"kjqua" <kj***@pippo.it wrote in message
news:eZ******** ******@TK2MSFTN GP02.phx.gbl...

Hi all,

I am newbie in c# and i have a question regarding DataGridView
I have a Table with 3 Columns
(0)IdLeggiSeria le <Is Primary key>
(1)ValoreSerial e <Is Integer>
(2)DataAcquisiz ione <Is DateTime>
I will like to change the color of each row that
in the in column(1) "ValoreSeri ale" the Value is greater than 50.
private void dataGridView1_C ellFormatting(o bject sender,
DataGridViewCel lFormattingEven tArgs e)
{

if
(dataGridView1. Columns[e.ColumnIndex].Name.Equals("V aloreSeriale"))
{
Int32 intValue;
if (Int32.TryParse ((String)e.Valu e, out intValue) &&
(intValue 50))
{
e.CellStyle.Bac kColor = Color.Yellow;
e.CellStyle.Sel ectionBackColor = Color.DarkRed;
}
}
}

In the Above code i only change the color a singular cell.

How can i change all the row.

Thanks
Marco

[kjqua]

Hi Puja,

I try your function but i have this error:

The type or namespace name 'GridViewRowEve ntArgs' could not be found
(are you missing a using directive or an assembly reference?)

The dataGridView1 is on the form.

LeggiSeriale.md f is the name of my database

Seriale_1 Is the name of the Table
IdLeggiSeriale is the name of the 1 column in the Table Seriale_1
ValoreSeriale is the name of the 2 column in the Table Seriale_1
DataAcquisizion e is the name of the 3 column in the Table Seriale_1

thanks
Puja ha scritto:

hi

u could use below function and call this function OnRowCreated=Hi ghlightRow
in your grid view

protected void HighlightRow(Ob ject sender, GridViewRowEven tArgs e)

{

if (e.Row.RowType == DataControlRowT ype.DataRow)

{

//find your control here whether its a textbox or label

Label lblValoreSerial e= (Label)e.Row.Fi ndControl("lblV aloreSeriale");

if(lblValorSeri ale != null)

{

ifConvert.ToInt 32((lblValoreSe riale.Text) 50)

e.Row.BackColor = System.Drawing. Color.Aqua;

}

}

}

hope this helps
"kjqua" <kj***@pippo.it wrote in message
news:eZ******** ******@TK2MSFTN GP02.phx.gbl...

>Hi all,

I am newbie in c# and i have a question regarding DataGridView
I have a Table with 3 Columns
(0)IdLeggiSeri ale <Is Primary key>
(1)ValoreSeria le <Is Integer>
(2)DataAcquisi zione <Is DateTime>
I will like to change the color of each row that
in the in column(1) "ValoreSeri ale" the Value is greater than 50.
private void dataGridView1_C ellFormatting(o bject sender,
DataGridViewCe llFormattingEve ntArgs e)
{

if
(dataGridView1 .Columns[e.ColumnIndex].Name.Equals("V aloreSeriale"))
{
Int32 intValue;
if (Int32.TryParse ((String)e.Valu e, out intValue) &&
(intValue 50))
{
e.CellStyle.Bac kColor = Color.Yellow;
e.CellStyle.Sel ectionBackColor = Color.DarkRed;
}
}
}

In the Above code i only change the color a singular cell.

How can i change all the row.

Thanks
Marco

[Puja]

are u using dot net version 2.0? i am using same code and it works fine.

"kjqua" <kj***@pippo.it wrote in message
news:eJ******** ******@TK2MSFTN GP02.phx.gbl...

Hi Puja,

I try your function but i have this error:

The type or namespace name 'GridViewRowEve ntArgs' could not be found (are
you missing a using directive or an assembly reference?)

The dataGridView1 is on the form.

LeggiSeriale.md f is the name of my database

Seriale_1 Is the name of the Table
IdLeggiSeriale is the name of the 1 column in the Table Seriale_1
ValoreSeriale is the name of the 2 column in the Table Seriale_1
DataAcquisizion e is the name of the 3 column in the Table Seriale_1

thanks
Puja ha scritto:

>hi

u could use below function and call this function
OnRowCreated=H ighlightRow in your grid view

protected void HighlightRow(Ob ject sender, GridViewRowEven tArgs e)

{

if (e.Row.RowType == DataControlRowT ype.DataRow)

{

//find your control here whether its a textbox or label

Label lblValoreSerial e= (Label)e.Row.Fi ndControl("lblV aloreSeriale");

if(lblValorSer iale != null)

{

ifConvert.ToIn t32((lblValoreS eriale.Text) 50)

e.Row.BackColo r = System.Drawing. Color.Aqua;

}

}

}

hope this helps
"kjqua" <kj***@pippo.it wrote in message
news:eZ******* *******@TK2MSFT NGP02.phx.gbl.. .

>>Hi all,

I am newbie in c# and i have a question regarding DataGridView
I have a Table with 3 Columns
(0)IdLeggiSer iale <Is Primary key>
(1)ValoreSeri ale <Is Integer>
(2)DataAcquis izione <Is DateTime>
I will like to change the color of each row that
in the in column(1) "ValoreSeri ale" the Value is greater than 50.
private void dataGridView1_C ellFormatting(o bject sender,
DataGridViewC ellFormattingEv entArgs e)
{

if
(dataGridView 1.Columns[e.ColumnIndex].Name.Equals("V aloreSeriale"))
{
Int32 intValue;
if (Int32.TryParse ((String)e.Valu e, out intValue) &&
(intValue 50))
{
e.CellStyle.Bac kColor = Color.Yellow;
e.CellStyle.Sel ectionBackColor = Color.DarkRed;
}
}
}

In the Above code i only change the color a singular cell.

How can i change all the row.

Thanks
Marco