Datagridview checkboxes in Sqlce database

[KeesBlunder]

Hello,

With this i fill a datagridview and put a checkbox in the datagridview.

cmd = New SqlCeCommand("Select * FROM Bemanning", con)
If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlCeDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "MyTable")
DataGridView1.DataSource = myDataSet.Tables("MyTable").DefaultView

If con.State = ConnectionState.Closed Then con.Open()

cmd.ExecuteNonQuery()

Dim checkBoxColumn As New DataGridViewCheckBoxColumn()
checkBoxColumn.HeaderText = "Selecteer"
checkBoxColumn.Width = 30
checkBoxColumn.Name = "checkBoxColumn"
DataGridView1.Columns.Insert(0, checkBoxColumn)

But can i save the checkboxes to the sqlce database so it is showing the next time the one's i selected.



Continue reading...