SQL Compact 3.5 database VB 2008 WinForm design RRS feed

  • Question

  • In a SQL Compact 3.5 database, I have a table which populates a dataset displayed in a datagridview on a windows form. The user selects which rows to include/exclude on the basis of a checkbox column in each row of the datagrid. I would like a real-time update of the datagrid whenever a row is included or excluded. Any suggested code samples would be helpful.

    When using Linq to dataset, is it better to set up duplicate datasets (of included and excluded rows) and move rows between the datasets, or use a single dataset and re-populate the datagrid by re-executing the Linq query to select the appropriate rows?

    Thanks, -Brian
    Monday, November 17, 2008 9:57 PM