changing cell colour of on a gridview

Question

0.00/5 (No votes)

See more:

hi
i am using VS2010 and i have created a page that, when the user clicks a button it will allow them to view the spreadsheet that they want to upload to an sql server. this is basically just to allow them, to check that it is in the right format and all cells are populated. the spreadhseet information is displayed in a gridview. but what i want is to change the cell background colour of a specific cell that is blank/does not contain any information, so the user can see that there is missing information.

can someone please help

thanks :-)

Posted 12-May-11 4:08am

Kay Reid

Add a Solution

5 solutions

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)

ankitjoshi24 · Answer 1 · 2011-05-12T05:08:00

I am not sure but may be the following code will help : -

VB

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim col As Integer = 0
        While col < GridView1.Columns.Count
            Dim rowvalue As String = e.Row.Cells(col).Text
            If rowvalue = "" Then
                e.Row.Cells(col).BackColor = System.Drawing.Color.Red
            Else
                e.Row.Cells(col).BackColor = System.Drawing.Color.White
            End If
            col += 1
        End While
    End If
End Sub

Let me know if it works

--
AJ

Tarun.K.S · Answer 2 · 2011-05-12T04:20:00

Solution 1

This should help you:

http://stackoverflow.com/questions/3146456/how-can-i-change-the-background-color-of-a-gridview-cell-based-on-a-conditional[^]

http://www.dotnetspark.com/Forum/253-change-background-color-cell-gridview-programatically.aspx[^]

Posted 12-May-11 4:20am

Tarun.K.S

Kay Reid · Answer 3 · 2011-05-12T23:09:00

no :-( none of them worked.

the code that i am using to view the spreadsheet before it is imported into the sql serv is as follows
Protected Sub ButtonView_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonView.Click
PanelUpload.Visible = False
PanelView.Visible = True
PanelImport.Visible = False

Dim objDataAdapter As New OleDbDataAdapter()

objDataAdapter.SelectCommand = ExcelConnection()

Dim objDataSet As New DataSet()

objDataAdapter.Fill(objDataSet)

GridView1.DataSource = objDataSet.Tables(0).DefaultView
GridView1.DataBind()
End Sub

so when the user clicks this view button they will see the spreadsheet displayed in the gridview. but there are some cells in the spreadsheet that are empty and i need these cells to be changed to RED in the gridview :-(

is it possible?

Kay Reid · Answer 4 · 2011-05-13T00:26:00

Hi

i have searched again and this is some code that is working slighlty

VB

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

    If (e.Row.RowType = DataControlRowType.DataRow) Then
        lblgrid = e.Row.FindControl("lblsiteUPRN")
        lblgrid.Text = "X"
        If lblgrid.Text Is vbNullString Then

        End If


    End If

End Sub

this created a new column call siteUPRN and puts an x when it is blank in siteUPRN however, i do not want to create another column, i need the orginal siteUPRN (that is autogenerated from the spreadsheet) to be the one that is searched for a null value and an x (or colour change) put in the empty cell

reid0588 · Answer 5 · 2011-05-23T23:25:00

Solution 5

hi
i lost my login details for this post so i have had to re do everythin

this is now SOLVED as i have found out how to do it

cheers for you help everyone :-)

Posted 23-May-11 23:25pm

reid0588

changing cell colour of on a gridview

5 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0