check/uncheck checkbox in a gridview by fetching the value from database

See more:

VB

Windows

SQL-Server

WPF

, +

Hi all

I have 2 columns in my database table

name value
a     0
b     0
c     0
d     0

so now i want is if the value is 0 then the the checkboxes will be unchecked and when user check the checkbox the value should update to 1

Please tell me how to fetch the data and update the checkboxes.

At the first time i have to load the default value from database.later user will update and save.

This is my datagrid

<my:DataGrid Name="dgProducts" AutoGenerateColumns="False" Grid.Row="1" Grid.RowSpan="3" Grid.ColumnSpan="2" CanUserAddRows="False">
            <my:DataGrid.Columns>
                <my:DataGridTextColumn Header="Name" Binding="{Binding Path=ProductName}" Width="300"/>               
               
                <my:DataGridTemplateColumn>
                    <my:DataGridTemplateColumn.Header>
                        <CheckBox Content="Visible" Click="CheckBox_Click" Name="CheckBox1" />
                    </my:DataGridTemplateColumn.Header>
                    <my:DataGridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <CheckBox Name="chkDiscontinue" IsChecked="{Binding Path=Discontinue,Mode=TwoWay}" Margin="45 2 0 0" Click="chkDiscontinue_Click" />
                        </DataTemplate>
                    </my:DataGridTemplateColumn.CellTemplate>
                </my:DataGridTemplateColumn>
            </my:DataGrid.Columns>
        </my:DataGrid>

Thank you