You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »


Download the Solution Example: DataGridWithColors.dbsln

  • Solution Name: DataGridWithColors

  • Software Version: v10 Update 1b

  • Keywords: DataGrid. Colors. Customization. Rows. Cells.

Summary

This solution example customizes colors on the DataGrid object by defining events that modify row and cell colors based on specific rules.

Technical Information

This example stores simulated data in a DataTable-type tag, which is populated in the code-behind. The data can also come from a database. Remember to configure the Data Source field in the DataGrid Settings dialog to ensure the data is displayed correctly. See the images below for an example of the configuration.

Key Features

In this example, the method OnCustomizeRow applies alternating row colors based on index parity, while OnCustomizeCell modifies cell color based on it is value.

Row Customization

Method to Customize Rows
private void OnCustomizeRow(DataRow row, Dictionary<string, object> attributes) {
    // Retrieves the total number of rows in the table.
    int rowCount = row.Table.Rows.Count;
    // Retrieves the index of the current row in the table.
    int idx = row.Table.Rows.IndexOf(row);
    
    // Defines default color.
    string textColor = "#000000";
    string bgColor = "#FFFFFF";
    
    // Alternates colors for even and odd row indices.
    if (idx % 2 == 0) {
        textColor = "#000000";
        bgColor = "#DAF3DB";
    }
    
    // Assigns the foreground and background colors to the row attributes.
    attributes["Foreground"] = textColor;
    attributes["Background"] = bgColor;
}


Cell Customization

Method to Customize Cells
private void OnCustomizeCell(string columnName, DataRow row, Dictionary<string, object> attributes) {
    // Logs debug information when the method executes.
    @Info.Trace($"[DEBUG] || OnCustomizeCell || col: {columnName} || [1] ");
    
    // Exits the method if the column is not named "Status".
    if (!string.Equals(columnName, "Status"))
        return;
    
    // Logs debug information when the column matches "Status".
    @Info.Trace($"[DEBUG] || OnCustomizeCell || col: {columnName} || [2] ");
    
    // Retrieves the value of the "Status" column
    string status = row["Status"]?.ToString();
    if (string.IsNullOrEmpty(status))
        return;
    
    // Logs debug information about the retrieved value.
    @Info.Trace($"[DEBUG] || OnCustomizeCell || col: {columnName} || Row[col]: {row[columnName]} || [3] ");
    
    // Apply background and text colors based on status value using if-else
    if (status.Contains("2nd Pass Press")) {
        attributes["Foreground"] = "#FFFFFF";
        attributes["Background"] = "#00B9B6";
    } else if (status.Contains("Finished Press")) {
        attributes["Foreground"] = "#000000";
        attributes["Background"] = "#8BE27C";
    } else if (status.Contains("Finish Slit")) {
        attributes["Foreground"] = "#000000";
        attributes["Background"] = "#FCFD1A";
    } else if (status.Contains("Start Slit")) {
        attributes["Foreground"] = "#FFFFFF";
        attributes["Background"] = "#1929A9";
    } else if (status.Contains("Finished Lam")) {
        attributes["Foreground"] = "#000000";
        attributes["Background"] = "#57D845";
    } else if (status.Contains("2nd Pass Lam")) {
        attributes["Foreground"] = "#FFFFFF";
        attributes["Background"] = "#1A2B7E";
    }
}

Reference Information

→ See DataGrid Control for more information.

In this section:

The root page @parent could not be found in space v10.

  • No labels