c# WPF execute query for many bases from datagrid

Question

I have datagrid with all my basses information: 1. First column - checkbox 2.Second column - database name 3.info 4.info I need to execute query for every checked with chekbox database. In Winforms i do with this code :

  foreach (DataGridViewRow item in dataGridView1.Rows)
            {
  DataGridViewCheckBoxCell chk = item.Cells[0] as DataGridViewCheckBoxCell;


                if (Convert.ToBoolean(chk.Value) == true)
                {

and before executenonquery this line :

connection.ChangeDatabase(item.Cells[1].Value.ToString());

Can someone help me to convert to WPF version? I need to show me second column(row) if first column(chebox) is checked.

XAML :

<DataGrid x:Name="dataGrid" HorizontalAlignment="Left" Margin="490,0,0,0" VerticalAlignment="Top" Height="142" Width="728" SelectionChanged="dataGrid_SelectionChanged" >
                        <DataGrid.Columns>
                            <DataGridCheckBoxColumn Binding="{Binding BoolProperty, UpdateSourceTrigger=PropertyChanged}">
                                <DataGridCheckBoxColumn.ElementStyle>
                                    <Style TargetType="CheckBox"/>
                                </DataGridCheckBoxColumn.ElementStyle>
                            </DataGridCheckBoxColumn>
                        </DataGrid.Columns>
                    </DataGrid>

This fill my dataGrid:

        con.server = this.server;
        con.user = this.user;
        con.password = this.password;
        con.OpenConnection();
        con.SqlQuery(Properties.Resources.databaseCatalogResource);
        DataTable dt = con.QueryEx();
        con.da.Fill(dt);
        dataGrid.ItemsSource = dt.DefaultVie

w;

https://stackoverflow.com/questions/15686381/wpf-iterate-through-datagrid — Sebastian Siemens, Aug 16 '17 at 08:00
this help me but shows me textfields of all lines. I need to show me second row if first(chebox) is checked. — Димитър Грудев, Aug 16 '17 at 09:00
If you need logic in your datagrid, i would recommend using an observablecollection and using this as the itemsource of the datagrid. if the observablecollection is changed you can react to that with an event. In the Event method you can add/remove rows or use other logic to change the collection. the changes of the collection are automatically passed to the UI/Datagrid. — Sebastian Siemens, Aug 16 '17 at 09:13
If you want to use checkbox column then look at this. also you can check if the value of the checkbox is true or false like in your example code. — Sebastian Siemens, Aug 16 '17 at 09:25
oky but it's little hard for me. here is hard for me : DataGridViewCheckBoxCell chk = item.Cells[0] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(chk.Value) == true) { — Димитър Грудев, Aug 16 '17 at 09:28
How did you set the ItemsSource property of the DataGrid and how is your XAML defined? — mm8, Aug 16 '17 at 10:17
It is still unclear how you set the ItemsSource property of fill the DataGrid with items. — mm8, Aug 16 '17 at 10:32
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/152036/discussion-between---and-mm8). — Димитър Грудев, Aug 16 '17 at 10:53

score 1 · Accepted Answer · answered Aug 16 '17 at 10:56

1

You could iterate through the DataView:

DataView dv = dataGrid.ItemsSource as DataView;
foreach(DataRowView drv in dv)
{
    if(Convert.ToBoolean(drv["BoolProperty"]))
    {
        //row is checked...
    }
}

Of course your DataTable must contain a column called "BoolProperty" since you bind your CheckBox to this one. If it doesn't you need to add one:

con.server = this.server;
con.user = this.user;
con.password = this.password;
con.OpenConnection();
con.SqlQuery(Properties.Resources.databaseCatalogResource);
DataTable dt = con.QueryEx();
con.da.Fill(dt);
dt.Columns.Add(new DataColumn("BoolProperty", typeof(bool))); //<---
dataGrid.ItemsSource = dt.DefaultView;

answered Aug 16 '17 at 10:56

mm8

163,881
10
57
88

How can set value of this column? – Димитър Грудев Aug 17 '17 at 06:57
i try with this : DataRow dr = dt.NewRow(); dr["BoolProperty"] = true; but not work – Димитър Грудев Aug 17 '17 at 07:20
1

Please ask a new question if you have another issue. – mm8 Aug 17 '17 at 09:15

c# WPF execute query for many bases from datagrid

1 Answers1