how to fill selected rows in datagridview with green colour?

Question

1.00/5 (1 vote)

See more:

i have 1 column named as date.

but some rows are blank and some rows are filled with date in datagridview

now i want to colour the blank rows of date as green and filled date rows as red.

how do i do that?

what is the condition that i will write?

please can anyone help me

thanks in advance.

i will be very obliged

Posted 15-Jul-13 22:21pm

sudeshna from bangkok

Updated 15-Jul-13 22:42pm

v2

Add a Solution

2 solutions

Solution 1

VB

For Each rw As GridViewRow In dgrd_WWWH.Rows
            If String.IsNullOrEmpty(rw.Cells("date").ToString()) Then
                rw.BackColor = Drawing.Color.Green
            Else
                rw.BackColor = Drawing.Color.Red
            End If
        Next

this code for asp.net vb code

Posted 15-Jul-13 22:46pm

senthil kumar - 2185

Comments

sudeshna from bangkok 16-Jul-13 5:11am

thanks but i want the same code in vb.net not in asp.net

[no name] 16-Jul-13 5:16am

yes little bit gridviewrow changes as datagridviewrow

sudeshna from bangkok 18-Jul-13 6:16am

can you give me the code in vb.net instead of asp.net?

[no name] 18-Jul-13 6:57am

For Each rw As DataGridViewRow In DataGridView1.Rows
If String.IsNullOrEmpty(rw.Cells("slno").Value) Then
rw.DefaultCellStyle.BackColor = Color.Green
Else
rw.DefaultCellStyle.BackColor = Color.Red
End If
Next

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SITU.PATI · Accepted Answer · 2013-07-15T22:57:00

Solution 2

XML

Hi Sudeshna,
Here i am giving you the code for your problem.
So do as you have done adding the data to the datagrid view. Now add these code for evaluation of the rowdata and its values for coloring.

<code>Dim i As Integer
        For i = 0 To DataGridView1.Rows.Count - 1
            If IsNothing(DataGridView1.Rows(i).Cells(0).Value) Then
                DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.Green
            Else
                DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.Red
            End If
        Next</code>
here the cells(0) refers to the column where the date data is entered. I think it will solve your problem.
Thank you

Posted 15-Jul-13 22:57pm

SITU.PATI

Comments

sudeshna from bangkok 16-Jul-13 5:23am

thanks but there is no function like isnothing. its not showing

SITU.PATI 16-Jul-13 5:25am

WHICH VERSION OF VISUAL STUDIO YOU ARE USING?

sudeshna from bangkok 16-Jul-13 5:30am

visual studio 2008 express edition

SITU.PATI 16-Jul-13 5:30am

USE THIS ONE ALSO.
Microsoft.VisualBasic.Information.IsNothing(DataGridView1.Rows(i).Cells(0).Value)INSTEAD OF ISNOTHING

sudeshna from bangkok 16-Jul-13 5:31am

visual studio 9.0

SITU.PATI 16-Jul-13 5:32am

NOW OT WILL WORK MADAM. NO PROBLEM. USE THE ABOVE STRUCTURAL VALUE FOR ISNOTHING FUNCTION

sudeshna from bangkok 16-Jul-13 5:33am

still not coming. isnothing

sudeshna from bangkok 16-Jul-13 5:33am

after information isnothing not showing

SITU.PATI 16-Jul-13 5:36am

USE THIS ONE
If DataGridView1.Rows(i).Cells(0).Value = Nothing Then

sudeshna from bangkok 16-Jul-13 5:37am

its not showing still. isnothing not coming. isdbnull showing and some other isfunctions

SITU.PATI 16-Jul-13 5:39am

nO SUDESHNA MADAM I HAVE PROVIDED ANOTHER WAY OF CHECKING NOTHING VALUES TO CHECK WHETHER THE DATABGRID HAS SOME VALUES IN ITS CELL OR NOT. PLEASE CHECK IT DOWN. IT IS A STANDARD FUNCTION FOR EVERY VISUAL STUDIO APPLICTION. BUT I DONT KNOW WHY THIS FUNCTION IS NOT AVIALABLE

SITU.PATI 16-Jul-13 5:45am

TRY THIS CODE ALSO
Dim i As Integer
For i = 0 To DataGridView1.Rows.Count - 1
'If Microsoft.VisualBasic.Information.I(DataGridView1.Rows(i).Cells(0).Value) Then
'If DataGridView1.Rows(i).Cells(0).Value = Nothing Then
If String.IsNullOrEmpty(DataGridView1.Rows(i).Cells(0).Value) Then
DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.Green
Else
DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.Red
End If
Next

sudeshna from bangkok 16-Jul-13 5:48am

in your code,all rows are getting filled with red and blank rows are getting filled with red.

i want only the date column which are blank to be filled with green and that same date column when date is there, to be filled with red.

can you help me again.

please.
thanks in advance

sudeshna from bangkok 16-Jul-13 5:51am

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim da As New SqlDataAdapter
Dim cmd As New SqlCommand
Dim ds As New DataSet
Dim tb2 As DataTable
Dim i As Integer

Try
cmd.Connection = cn
cn.Open()
da = New SqlDataAdapter("select * from facsort", cn)
tb2 = New DataTable
da.Fill(tb2)
FacsortDataGridView.DataSource = tb2
For i = 0 To Me.FacsortDataGridView.Rows.Count - 1

If Me.FacsortDataGridView.Rows(i).Cells("return_dt").Value = Nothing Then
Me.FacsortDataGridView.Rows(i).DefaultCellStyle.BackColor = Color.Green
Else
Me.FacsortDataGridView.Rows(i).DefaultCellStyle.BackColor = Color.Red

End If
Next
cn.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

SITU.PATI 16-Jul-13 5:51am

For i = 0 To DataGridView1.Rows.Count - 1

If String.IsNullOrEmpty(DataGridView1.Rows(i).Cells(0).Value) Then
DataGridView1.Rows(i).Cells(0).Style.BackColor = Color.Green
Else
DataGridView1.Rows(i).Cells(0).Style.BackColor = Color.Red
End If
Next
End Sub

sudeshna from bangkok 16-Jul-13 5:53am

i have written this code,but showing error that operator = is not defined for type DBnull and nothing

SITU.PATI 16-Jul-13 5:54am

press ctrl+alt+j, it will open object browser. Search isnothing function there.

sudeshna from bangkok 16-Jul-13 5:57am

For i = 0 To Me.FacsortDataGridView.Rows.Count - 1

If String.IsNullOrEmpty(FacsortDataGridView.Rows(i).Cells("return_dt").Value) Then
FacsortDataGridView.Rows(i).Cells(0).Style.BackColor = Color.Green
Else
FacsortDataGridView.Rows(i).Cells(0).Style.BackColor = Color.Red
End If
Next

sudeshna from bangkok 16-Jul-13 5:58am

wrote this code,showing error at runtime that conversion from type DBnull to type string not possible

SITU.PATI 16-Jul-13 6:00am

which line it is showing errors.

SITU.PATI 16-Jul-13 6:01am

you can use FacsortDataGridView.Rows(i).Cells("return_dt").Value.tostring to avoid these errors

sudeshna from bangkok 16-Jul-13 6:14am

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim da As New SqlDataAdapter
Dim cmd As New SqlCommand
Dim ds As New DataSet
Dim tb2 As DataTable

Try
cmd.Connection = cn
cn.Open()
da = New SqlDataAdapter("select * from facsort", cn)
tb2 = New DataTable
da.Fill(tb2)
FacsortDataGridView.DataSource = tb2
For i As Integer = 0 To Me.FacsortDataGridView.Rows.Count - 1

If String.IsNullOrEmpty(FacsortDataGridView.Rows(i).Cells("return_dt").Value.ToString()) Then
Me.FacsortDataGridView.Rows(i).Cells("return_dt").Style.BackColor = Color.Green
Else
Me.FacsortDataGridView.Rows(i).Cells("return_dt").Style.BackColor = Color.Red
End If
Next
cn.Close()

Catch ex As Exception
MsgBox(ex.Message)
End Try

sudeshna from bangkok 16-Jul-13 6:15am

yes,i have done it. its working fine except at runtime its showing a msgbox error that object reference not set to an instance of an object

SITU.PATI 16-Jul-13 6:18am

which object it is showing the instance error?

sudeshna from bangkok 16-Jul-13 6:21am

i dont know,at runtime its showing error in msgbox

sudeshna from bangkok 16-Jul-13 6:21am

Imports System.Data.SqlClient
Imports System.Data
Public Class Form8
Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim da As New SqlDataAdapter
Dim cmd As New SqlCommand
Dim ds As New DataSet
Dim tb3 As DataTable

Private Sub Form8_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'RecordDataSet.facsort' table. You can move, or remove it, as needed.
' Me.FacsortTableAdapter.Fill(Me.RecordDataSet.facsort)
'TODO: This line of code loads data into the 'RecordDataSet.facsort' table. You can move, or remove it, as needed.
Me.FacsortTableAdapter.Fill(Me.RecordDataSet.facsort)

End Sub

Private Sub FacsortBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
Me.FacsortBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.RecordDataSet)

End Sub

Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim da As New SqlDataAdapter
Dim cmd As New SqlCommand
' Dim ds As New DataSet
Dim tb3 As DataTable

Try
cmd.Connection = cn
cn.Open()
da = New SqlDataAdapter("select * from facsort", cn)
tb3 = New DataTable
da.Fill(tb3)
FacsortDataGridView.DataSource = tb3
For i As Integer = 0 To Me.FacsortDataGridView.Rows.Count - 1

If String.IsNullOrEmpty(FacsortDataGridView.Rows(i).Cells("return_dt").Value.ToString()) Then
Me.FacsortDataGridView.Rows(i).Cells("return_dt").Style.BackColor = Color.Green
Else
Me.FacsortDataGridView.Rows(i).Cells("return_dt").Style.BackColor = Color.Red
End If
Next
cn.Close()

Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub

Private Sub FacsortBindingNavigatorSaveItem_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FacsortBindingNavigatorSaveItem.Click
Me.Validate()
Me.FacsortBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.RecordDataSet)

End Sub
End Class

sudeshna from bangkok 16-Jul-13 6:22am

this is my full code in that particular form.

sudeshna from bangkok 16-Jul-13 6:30am

did u find why that error coming at runtime?

sudeshna from bangkok 16-Jul-13 6:42am

did u find it? please let me know. i too cant find why its coming at runtime that error in msgbox.

please sir, if you help me in finding,i will instantly accept the solution as you were the one who helped me with the code.

i owe you a lot.

thanks a lot.

SITU.PATI 16-Jul-13 11:17am

i cant get to that error, unless i know why the error occured. In my system i dont get any type of error such that

sudeshna from bangkok 17-Jul-13 1:12am

how to debug can you tell me? then i will check

sudeshna from bangkok 17-Jul-13 1:13am

i am still getting that error

sudeshna from bangkok 17-Jul-13 1:31am

error is showing in that line string.isnullorempty. as vb.net in string something has to be aasigned.

check this link

http://codebetter.com/raymondlewallen/2005/06/23/system-nullreferenceexception-object-reference-not-set-to-an-instance-of-an-object-3-common-causes-in-vb-net/

sudeshna from bangkok 17-Jul-13 1:42am

can you plz help me again,please.

i request you.

sudeshna from bangkok 17-Jul-13 4:49am

hello again, i debugged the code and saw its showing error in last line,where 1 blank row comes automatically in gridview, so my if statement is checking that whole blank row and then that error is showing.

can you change the if statement or can you modify it so that it checks for null values also.

sudeshna from bangkok 17-Jul-13 4:51am

please help me as i am running your code only and its showing error in last blank row at last return_dt column as its finding null values and then showing the error in messagebox at run time.

please help me. i request you. kindly update the if statement to something else or give another code where it checks for null values also

SITU.PATI 17-Jul-13 11:01am

SORRY SUDESHNA, I WAS FULLY PACKED WITH WORK, SORRY FOR THE DELAY. i DONT KNOW WHY YOUR SYSTEM IS GENERATING THE ERROR, SINCE MY SYSTEM DOES NOT SHOW.
IF YOU USE THIS STATEMENT
IT CAN ALSO
If (DataGridView1.Rows(i).Cells(0).Value = Nothing) Then

sudeshna from bangkok 17-Jul-13 22:49pm

but this line i have used its showing error

sudeshna from bangkok 18-Jul-13 1:32am

sir,can u help me please,as i am using your code only. can you modify your code to something else.

SITU.PATI 18-Jul-13 3:36am

Sorry Sudeshna Madam, Can you please tell me which .net framework version you are using?

sudeshna from bangkok 18-Jul-13 5:26am

i am using .net 3.0 sp2

sudeshna from bangkok 18-Jul-13 5:40am

please can you help. this error is creating a problem in my code, cant move next step also.
any modification in code please let me know

sudeshna from bangkok 18-Jul-13 6:15am

helo,please can you help. im stuck here in this part of code. showing error at runtime with null values at runtime.

please help.

SITU.PATI 18-Jul-13 6:21am

SUDESHNA ARE YOU THERE?
DO YOU HAVE TEAM VIEWER INSTALLED IN YOUR SYSTEM.

SITU.PATI 18-Jul-13 6:27am

IF YOU HAVE TEAMVIWER THEN I CAN DIRECTLY CONNECT TO YOUR SYSTEM AND DIRECTLY SOLVE THE PROBLEM AS WELL AS I CAN SEE THE ACTUAL PROBELM