How to change row color from datagrid on condition? It is importan for me

Question

1.00/5 (1 vote)

See more:

this my code for load Database to datagrid

C#

var data = from p in dc.ToplantiTalepFormus from c in dc.Onays where 
               (p.Toplanti_Talep_ID == c.Toplanti_Talep_ID &&
               (c.Talep_eden_ID==ID || c.User_ID == ID))
           select new 
           {
               p.Toplanti_Talep_ID, p.Toplanti_Talep_Tarihi, 
               p.Toplanti_Tarihi, p.Toplanti_Saat, 
               p.Toplanti_Konusu, p.Toplanti_Yeri,
               p.Toplanti_Şekli, p.Toplantı_Durumu, 
               c.Toplantı_Onay, c.Yeni_Tarih, 
               c.Yeni_Saat, c.DeğişiklikOnay ,c.User_ID
           };

foreach (var ToplantiTalepFormus in data)
{
    Datagrid.ItemsSource = data.ToList();
}

What I have tried:

but when User Id is = user ID or somthing else I want to make row is red. Please help me

C#

private void Liste()
{
    ID = Convert.ToInt32(MainWindow.UserID);

    var data = from p in dc.ToplantiTalepFormus from c in dc.Onays where 
        p.Toplanti_Talep_ID == c.Toplanti_Talep_ID select new { p.Toplanti_Talep_ID,
        p.Toplanti_Talep_Tarihi, p.Toplanti_Tarihi, p.Toplanti_Saat,
        p.Toplanti_Konusu, p.Toplanti_Yeri, p.Toplanti_Şekli, p.Toplantı_Durumu,
        c.Toplantı_Onay, c.Yeni_Tarih, c.Yeni_Saat, c.DeğişiklikOnay, c.User_ID };

    foreach (var ToplantiTalepFormus in data)
    {
        if (ToplantiTalepFormus.User_ID == 1)
        {
            Datagrid.RowBackground = Brushes.Red;
        }
        Datagrid.ItemsSource = data.ToList();
    }
}

Posted 14-Sep-17 20:42pm

ANIL AYDINALP

Updated 15-Sep-17 0:20am

Graeme_Grant

v3

Add a Solution

Comments

Graeme_Grant 15-Sep-17 5:14am

or somthing else

We can't read your mind. Please update your question explaining how you want the condition to work.

ANIL AYDINALP 15-Sep-17 5:33am

you can see my code when it is loading by my code from question if it is find user ID ==1 and then make that row make red I mean that

ANIL AYDINALP 15-Sep-17 5:51am

[code moved to question]
this is I try to do it but When I do

if (ToplantiTalepFormus.User_ID == 1)
{
    Datagrid.RowBackground = Brushes.Red;
}

it gives all rows is red I need just specific row is red

1 solution

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)

Graeme_Grant · Answer 1 · 2017-09-14T22:02:00

This wpf datagrid conditional row color - Google Search[^] found: wpf - How to set DataGrid's row Background, based on a property value using data bindings - Stack Overflow[^]

UPDATE: As you are not using data binding, here is a code-behind version.

C#

public partial class MainWindow : Window
{
    public MainWindow()
    {
        InitializeComponent();
        Mock();
    }

    public ObservableCollection<Person> Persons { get; }
        = new ObservableCollection<Person>();

    private void Mock()
    {
        var rnd = new Random();

        for (int i = 0; i < 100; i++)
        {
            Persons.Add(new Person
            {
                Name = $"Person {i}", 
                Age = rnd.Next(20, 50)
            });
        }

        DataGrid1.LoadingRow += DataGrid1_LoadingRow;
        DataGrid1.ItemsSource = Persons;
    }

    private void DataGrid1_LoadingRow(object sender, DataGridRowEventArgs e)
    {
        var row = e.Row;
        var person = row.DataContext as Person;
        if (person.Age > 30 && person.Age < 40)
        {
            row.Background = new SolidColorBrush(Colors.Red);
        }
    }
}

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

UPDATE #2: Here is a Hierarchical DataGrid version... Works the same, just wired up a little different...

C#

public partial class MainWindow : Window
{
    public MainWindow()
    {
        InitializeComponent();
        Mock();
    }

    public ObservableCollection<Parent> Parents { get; }
        = new ObservableCollection<Parent>();

    private void Mock()
    {
        var rnd = new Random();

        for (int i = 0; i < 100; i++)
        {
            var parent = new Parent { Name = $"Parent {i}", Age = rnd.Next(20, 50) };

            for (int j = 0; j < 20; j++)
            {
                parent.Children.Add(new Person
                {
                    Name = $"Child {i}",
                    Age = rnd.Next(1, 10)
                });
            }

            Parents.Add(parent);
        }

        DataGrid1.LoadingRow += DataGrid1_LoadingRow;
        DataGrid1.ItemsSource = Parents;
    }

    private void DataGrid1_LoadingRow(object sender, DataGridRowEventArgs e)
    {
        var row = e.Row;
        var person = row.DataContext as Person;
        if (sender == DataGrid1)
        {
            if (person.Age > 30 && person.Age < 40)
            {
                row.Background = new SolidColorBrush(Colors.Red);
            }
        }
        else if (person.Age > 4 && person.Age < 6)
        {
            row.Background = new SolidColorBrush(Colors.Green);
        }
    }
}

public class Parent : Person
{
    public ObservableCollection<Person> Children { get; }
        = new ObservableCollection<Person>();
}

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

And the XAML...

XML

<Window
    x:Class="DataGridCodeBehindRowColorTrigger.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    mc:Ignorable="d"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

    Title="CodeProject - DataGrid Custom Row Color"
    WindowStartupLocation="CenterScreen" Height="300" Width="600">
    <Grid>
        <DataGrid x:Name="DataGrid1"
                  GridLinesVisibility="None"
                  AlternatingRowBackground="GhostWhite" AlternationCount="1"
                  ScrollViewer.HorizontalScrollBarVisibility="Hidden"
                  AutoGenerateColumns="False" IsReadOnly="True"
                  RowDetailsVisibilityMode="VisibleWhenSelected"
                  VirtualizingPanel.ScrollUnit="Pixel">
            <DataGrid.Columns>
                <DataGridTextColumn Header="Name"
                                    Binding="{Binding Name}"
                                    Width="*" />
                <DataGridTextColumn Header="Age"
                                    Binding="{Binding Age}"
                                    Width="70"/>
            </DataGrid.Columns>
            <DataGrid.RowDetailsTemplate>
                <DataTemplate>
                    <DataGrid ItemsSource="{Binding Children}"
                              LoadingRow="DataGrid1_LoadingRow"
                              GridLinesVisibility="None"
                              AlternatingRowBackground="GhostWhite"
                              AlternationCount="1"
                              ScrollViewer.HorizontalScrollBarVisibility="Hidden"
                              AutoGenerateColumns="False" IsReadOnly="True">
                        <DataGrid.Columns>
                            <DataGridTextColumn Header="Name"
                                                Binding="{Binding Name}"
                                                Width="*" />
                            <DataGridTextColumn Header="Age"
                                                Binding="{Binding Age}"
                                                Width="70"/>
                        </DataGrid.Columns>
                    </DataGrid>
                </DataTemplate>
            </DataGrid.RowDetailsTemplate>
        </DataGrid>

    </Grid>

</Window>