Click here to Skip to main content
15,905,967 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 :-)

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

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
                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

Share this answer
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()


GridView1.DataSource = objDataSet.Tables(0).DefaultView
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?
Share this answer

i have searched again and this is some code that is working slighlty
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
Share this answer
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 :-)
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900