Display a color-coded project status

Hi,

In the table you are going to store your projects - you will have a status field. this will be numeric..
0 = Unassiged
1 = Pending
2 = Completed
3 = Past Due
4 = Closed

You can also have a table called something like app_status..
Where you can store the numeric value and the text value ... like above .... - you can also put a column in there for colour...

So when you load your projects  - you will be able to pickup the text value of the status and assign the appropriate colour...
What is nice is that if you store the colour in the table like that - if you want to change it - you change it in the Database and it will show the new colour all over (You can build a settings page to select the colours per status).

Thanks,
P

Thanks very much for your response.

What we don't want to do is have a user select colors by themselves.

I love your idea of having a fieldname called Color in status table but I needed, if possible, the syntax for displaying this info.

For instance:

Select projectName, Status, color from Project, Status where project.statusid = status.statusid

Can you please help me with the .net syntax? I use vb but c# is ok too.

Here is an example of what I am talking about.

The following code works as fars retrieving info and displaying.

On the summary page, StatusColor is displaying as Red, or White, Blue, depending on the status.

What I am having problem accomplishing is changing the color from text to the background color.

In other words, instead of reading Red, I want to see background color of Red displayed.

Can you please assist?

here is what I have so far:

        Private Function GetTasks() As DataSet
            Dim SQLStatement As String = "SELECT Project_ID,projName, DepartmentName, StatusName, StatusColor FROM tblProjects, tblStatus, tblDepartments Where tblProjects.statusID = tblStatus.StatusID and tblProjects.DeptID = tblDepartments.DepartmentID GROUP BY DepartmentName,ProjName,StatusName,project_id,statusColor ORDER BY DepartmentName"

            'instantiate sql connection and command object
            Dim myConnection As New SqlConnection("data source = Localhost;initial catalog = TaskList;Integrated Security=SSPI;")
            Dim myCommand As SqlDataAdapter = New SqlDataAdapter(SQLStatement, myConnection)

            '/declare myDataSet as DataSet
            Dim myDataSet As DataSet
            Dim RcdCount As Integer

            ' mark the Command as s Text
            myCommand.SelectCommand.CommandType = CommandType.Text

            '/create an instance of dataset
            myDataSet = New DataSet

            '/fill the dataset with returned records
            myCommand.Fill(myDataSet, "Contact")
            RcdCount = myDataSet.Tables("Contact").Rows.Count.ToString()
            'MyDataGrid.PageSize = CInt(ps.SelectedItem.Value)
            ResultCount = RcdCount
            RecordCount.Text = "<b><font color=red>" & RcdCount & "</font> records found"

            '/finally return dataset
            Return myDataSet
        End Function

Can anyone please jump in and help???

Hi,

Sorry for replying so late.
Ok - I see you created a function GetTasks() to return a Dataset to you.
Do you want to show the details in a gridview (I will assume this for now)...
so after you get the dataset...
you will bind it to a gridview

        GridView1.DataSource = GridDs
        GridView1.DataBind()

Add the RowDataBound event to the gridview

This is how mine looks like

    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
            Dim c As System.Drawing.Color
            c = System.Drawing.ColorTranslator.FromHtml(e.Row.DataItem("StatusColour"))
            e.Row.BackColor = c
        End If
    End Sub



I have a column called StatusColour in my table with the values in html format  -> #b3424a

This works as it colours the entire row the colour which is specified in the database ... you can apply it to a column only if you wish...

Let me know if this works for you :)

Ciao

Thanks a lot and sorry for late response.

I wanted it for datagrid, Can it be changed for datagrid?

Are you working with Vb.NET  or ASP.NET?????

asp.net, vb flavor

thanks