How To Get Background Color Of Datagridview In Visual Basic

Ochoa Scang1935 · Sunday, May 29, 2022

DataGridView row groundwork color

Hullo, all,

Is there whatever manner to modify DataGridView row color based on different row
data? for example, if row data in start cavalcade = 1, it is xanthous, if it is ii,
it is blueish, if 3 it is white. That ways how to loop DataGridData to get row
data, and so based on the different data to alter row background colour?

Thanks in advance!

Jun 26 '06 #1

half dozen 24612

Hello martin1,
after some modifications this will do...

Dim CountR Every bit Integer

For CountR = 0 To GridView1.Rows.Count - 1
Select Example GridView1.Rows(CountR).Cells(1).Text
Case "Austria" : GridView1.Rows(CountR).BackColor = Cartoon.Color.Yellow
Case "Brazil" : GridView1.Rows(CountR).BackColor = Cartoon.Color.Violet
Instance "Kingdom of belgium" : GridView1.Rows(CountR).BackColor = Cartoon.Color.Aqua
Case Else : GridView1.Rows(CountR).BackColor = Cartoon.Color.Coral
Stop Select

Next
Jack

Hi, all,
Is there whatever way to modify DataGridView row color based on unlike
row information? for example, if row information in get-go column = i, information technology is yellow,
if information technology is 2, information technology is bluish, if 3 information technology is white. That ways how to loop
DataGridData to become row information, so based on the dissimilar data to
change row background color?

Cheers in advance!

Jun 27 '06 #2

Give thanks you. Jack

another question is practise yuo know how to remove some columns from
DataGridView? whcih feature and function is used for this? Cheers

"Jack" wrote:

Hello martin1,
afterwards some modifications this will do...
Dim CountR As Integer

For CountR = 0 To GridView1.Rows.Count - one
Select Case GridView1.Rows(CountR).Cells(1).Text
Case "Republic of austria" : GridView1.Rows(CountR).BackColor = Drawing.Colour.Xanthous
Example "Brazil" : GridView1.Rows(CountR).BackColor = Drawing.Color.Violet
Case "Belgium" : GridView1.Rows(CountR).BackColor = Drawing.Color.Aqua
Case Else : GridView1.Rows(CountR).BackColor = Drawing.Color.Coral
End Select

Side by side
Jack

Hi, all,
Is there whatever way to change DataGridView row colour based on different
row data? for example, if row data in offset column = 1, it is xanthous,
if it is two, it is blueish, if 3 it is white. That means how to loop
DataGridData to get row data, and so based on the different data to
change row background color?

Thanks in advance!

Jun 27 '06 #3

martin1 wrote:

Thank y'all. Jack
another question is do yuo know how to remove some columns from
DataGridView? whcih characteristic and function is used for this? Thanks

"Jack" wrote:

Hello martin1,
after some modifications this volition do...
Dim CountR As Integer

For CountR = 0 To GridView1.Rows.Count - 1
Select Case GridView1.Rows(CountR).Cells(one).Text
Case "Republic of austria" : GridView1.Rows(CountR).BackColor = Cartoon.Colour.Yellow
Case "Brazil" : GridView1.Rows(CountR).BackColor = Cartoon.Color.Violet
Example "Belgium" : GridView1.Rows(CountR).BackColor = Drawing.Color.Aqua
Case Else : GridView1.Rows(CountR).BackColor = Drawing.Color.Coral
End Select

Next
Jack

Hullo, all,
Is in that location any mode to change DataGridView row color based on different
row information? for case, if row data in first column = 1, it is yellow,
if it is 2, it is blue, if three it is white. That means how to loop
DataGridData to get row data, then based on the different data to
modify row background colour?

Thanks in advance!

If the datasource is a datatable.

Tabular array.Columns(Column_Name).ColumnMapping() = MappingType.Hidden

B.

Jun 27 '06 #4

Thank yous. Brian,

how about datasource is DataGridView? which is pupulated from dataset

"Brian Tkatch" wrote:

martin1 wrote:
Thank y'all. Jack
another question is do yuo know how to remove some columns from
DataGridView? whcih feature and function is used for this? Cheers

"Jack" wrote:

Hi martin1,
later on some modifications this volition practise...
Dim CountR Equally Integer

For CountR = 0 To GridView1.Rows.Count - 1
Select Case GridView1.Rows(CountR).Cells(1).Text
Example "Austria" : GridView1.Rows(CountR).BackColor = Drawing.Color.Yellowish
Case "Brazil" : GridView1.Rows(CountR).BackColor = Drawing.Color.Violet
Case "Kingdom of belgium" : GridView1.Rows(CountR).BackColor = Drawing.Color.Aqua
Instance Else : GridView1.Rows(CountR).BackColor = Cartoon.Colour.Coral
End Select

Side by side
Jack
> Hi, all,
>
> Is there any way to change DataGridView row colour based on different
> row information? for example, if row information in first column = 1, it is yellow,
> if it is 2, it is blueish, if 3 it is white. That means how to loop
> DataGridData to get row information, then based on the different information to
> change row groundwork colour?
>
> Thanks in accelerate!
>

If the datasource is a datatable.

Tabular array.Columns(Column_Name).ColumnMapping() = MappingType.Hidden

B.

Jun 27 '06 #5

I effigy at present

DataGridView.Columns(colume_name).Visible = False

"martin1" wrote:

Thank you. Brian,
how about datasource is DataGridView? which is pupulated from dataset

"Brian Tkatch" wrote:

martin1 wrote:
Thank you. Jack
another question is practice yuo know how to remove some columns from
DataGridView? whcih feature and role is used for this? Thank you

"Jack" wrote:

> Howdy martin1,
> after some modifications this will do...
>
> Dim CountR As Integer
>
> For CountR = 0 To GridView1.Rows.Count - 1
> Select Instance GridView1.Rows(CountR).Cells(1).Text
> Case "Republic of austria" : GridView1.Rows(CountR).BackColor = Cartoon.Color.Yellowish
> Case "Brazil" : GridView1.Rows(CountR).BackColor = Cartoon.Colour.Violet
> Case "Belgium" : GridView1.Rows(CountR).BackColor = Drawing.Color.Aqua
> Case Else : GridView1.Rows(CountR).BackColor = Drawing.Color.Coral
> End Select
>
> Next
>
>
> Jack
>
>
> > Hi, all,
> >
> > Is at that place any way to change DataGridView row color based on different
> > row data? for example, if row data in first column = one, it is yellow,
> > if information technology is ii, information technology is blueish, if three it is white. That means how to loop
> > DataGridData to get row data, and then based on the different data to
> > change row groundwork color?
> >
> > Thanks in accelerate!
> >
>
>
>

If the datasource is a datatable.

Table.Columns(Column_Name).ColumnMapping() = MappingType.Hidden

B.

Jun 27 '06 #half dozen

martin1 wrote:

Cheers. Brian,
how well-nigh datasource is DataGridView? which is pupulated from dataset

"Brian Tkatch" wrote:

martin1 wrote:
Thank you. Jack
another question is do yuo know how to remove some columns from
DataGridView? whcih feature and function is used for this? Cheers

"Jack" wrote:

> How-do-you-do martin1,
> subsequently some modifications this will do...
>
> Dim CountR As Integer
>
> For CountR = 0 To GridView1.Rows.Count - 1
> Select Instance GridView1.Rows(CountR).Cells(1).Text
> Case "Austria" : GridView1.Rows(CountR).BackColor = Drawing.Colour.Yellow
> Case "Brazil" : GridView1.Rows(CountR).BackColor = Drawing.Color.Violet
> Case "Kingdom of belgium" : GridView1.Rows(CountR).BackColor = Drawing.Colour.Aqua
> Instance Else : GridView1.Rows(CountR).BackColor = Drawing.Color.Coral
> End Select
>
> Next
>
>
> Jack
>
>
> > Hi, all,
> >
> > Is in that location any way to change DataGridView row color based on different
> > row data? for example, if row data in get-go column = one, it is yellow,
> > if it is 2, it is blue, if 3 it is white. That ways how to loop
> > DataGridData to become row data, then based on the different information to
> > modify row background colour?
> >
> > Thanks in advance!
> >
>
>
>

If the datasource is a datatable.

Table.Columns(Column_Name).ColumnMapping() = MappingType.Hidden

B.

Then go up first. :)

MyDataGridView.DataSource.Tabular array.Columns(Column_Nam e).ColumnMapping() =
MappingType.Hidden

Only like every DataTable has a link to it's DefaultView every DataView
has a link to it'southward (parent) Tabular array.

BTW, if yous want context-sensitive help to appear, y'all have to tell the
editor whatr the DataSource is, since it otherwise volition not know (since
it can be a DataSet, DataTable, DataView...), and this is (ane of the
things) done via CType.

CType(MyDataGridView.DataSource,
DataView).Table.Columns(Column_Name).ColumnMapping () =
MappingType.Subconscious
B.

Jun 28 '06 #vii