How do I read a Datagrid, line by line?

Question

I have a DataGrid (WPF) filled by an external data source. I need to rotate the entire grid, checking the values of each row, column by column.

• How is it possible to do this?
• What is the "heart" of grid data?
• I can turn the data into a collection and then use a foreach to rotate and consult?
• I’ll have access to all the columns like this?

Answer 1

If the data has a type defined as shown in this example (Model), you can recover the items in various ways, see the example:

^{Note: if you do not have data type the last example is the most appropriate}

Example:

Model:

public class Modelo
{
    public int Id { get; set; }
    public String Nome { get; set; }
}

Filling in:

GridDados.AutoGenerateColumns = true;
GridDados.ItemsSource = new List<Modelo>(){
    new Modelo(){Id = 1, Nome = "Fulano 1"},
    new Modelo(){Id = 2, Nome = "Fulano 2"},
};

Recovering

List<Modelo> modelos = GridDados.Items.OfType<Modelo>().ToList();

or

foreach (Modelo modelo in GridDados.Items.OfType<Modelo>().ToList())
{
    int id = modelo.Id;
    String nome = modelo.Nome;
}

or

If the data is an anonymous type:

GridDados.ItemsSource = new object[]{
            new {Id = 1, Nome = "Fulano 1"},
            new {Id = 2, Nome = "Fulano 2"},
        }.ToArray();

foreach (dynamic item in GridDados.Items)
{
    int id = item.Id;
    String nome = item.Nome;
}

Debugging to find the item:

The dynamic in this specific case will assume at runtime the type that each item in the list. Like this Collection has a type of class Modelo the variable item assumed that guy. That is, "The Dynamic type is a static type that is defined by the Dynamic reserved word and the variable of this type can be ALL in principle, and at compile time the Dynamic type assumes any operation." (Marcorrati.Net, C# - The data type Dynamic, 2014. Available at: http://www.macoratti.net/11/02/c_din1.htm. Date Accessed: 26.Jun.2014)

or

With Datarowview:

foreach (DataRowView item in GridDados.Items.OfType<DataRowView>().ToArray())
{
      string CDESC_INEP = item["CDESC_INEP"].ToString();                    
}

References:

• C# - The Dynamic data type

• Using the Dynamic type (C Programming Guide#)

• Dynamic (Reference of C#)

• Itemscontrol.Itemssource Property

• Datagrid Class

• Datarowview class