C # Connect a local SDF database file

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;//SDF is the CE version, you need to use this driver.Namespace TESTC
{
public partial class Form1:form
{
SqlCeConnection Sqlcecon = new SqlCeConnection ();//sqlceconnection
SqlCeCommand sqlcecom = new SqlCeCommand ();
DataTable dt = new DataTable (); Public Form1 ()
{
InitializeComponent ();
private void Form1_Load (object sender, EventArgs e)
{
Sqlcecon = new SqlCeConnection ("Data source=c:\\northwind.sdf");
Sqlcecon.open (); SqlCeDataAdapter adptrodbc = new SqlCeDataAdapter ("SELECT * from Customers", Sqlcecon);
Adptrodbc.fill (DT); Datagridview1.datasource = DT;
}
}
}

C # Connect a local SDF database file