C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace DataGridViewTest
{
    public partial class Form1 : Form
    {
        private System.Windows.Forms.DataGrid dataGrid1; // definieren des neuen DataGrids

        public Form1()
        {
            InitializeComponent();
            
            // Define first a DataGrid and declare a new DataGrid, and then set some properties of the DataGrid (location, name, size etc..).
            this.dataGrid1 = new System.Windows.Forms.DataGrid(); // deklarieren des DataGrids
            this.dataGrid1.Location = new System.Drawing.Point(20, 20); // positionieren des DataGrids
            this.dataGrid1.Name = "dataGrid1"; // DataGrid mit einem Namen Versehen
            this.dataGrid1.Size = new System.Drawing.Size(200, 100); // Grösses des DataGrids angeben
        }

        // Now we can put all the commands needed into a method "fnDisplayDataInDataGrid()", to display data in the DataGrid.
        private void fnDisplayDataInDataGrid()
        {
            // Verbindung zur Datenbank herstellen
            string conStr = "Data Source=C:\\CSharp\\DataGridViewTest\\DB_Personen.sdf";
            SqlCeConnection conn = new SqlCeConnection(conStr);

            conn.Open(); // Verbindung zur Datenbank öffnen

            SqlCeDataAdapter adapter = new SqlCeDataAdapter("SELECT * FROM Adressen", conn); // Erstellen des DataAdapter Objekts
            DataSet ds = new DataSet(); // Erstellen des DataSet Objekts
            adapter.Fill(ds, "Adresse"); // Tabelle "Adresse" in DataAdapter laden 

            this.dataGrid1.DataSource = ds.DefaultViewManager; // Anzeigen der Daten im DataGrid
            // alternativ würde auch folgendes funktionieren:
            // this.dataGrid1.SetDataBinding(ds,"Adresse");
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            fnDisplayDataInDataGrid();
        }
    }
}

A first chance exception of type 'System.DllNotFoundException' occurred in System.Data.SqlServerCe.dll