I have a SQL CE Database that I want to display its data on a **DataGrid**. 
I could do a SQL query then do a loop of **Items.Add** to the **DataGrid**. But I wonder is it possible to bind the SQL CE database to **DataGrid** directly without refreshing through a loop or using DataReader.

For instance, if there are new rows added to the Database, the DataGrid will display it automatically without me manually refreshing it (eg. a Button with SQL query).

I tried along the below approach but it didn't work out:

```
dataGrid1.ItemsSource = connString.Database;

```

Any suggestion? (BTW, I am creating all my Controls in run-time, so no XAML solution)