using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
namespace create_table
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
DataSet GlobalDS;
private void button1_Click(object sender, EventArgs e)
{
string ConnString;
ConnString = "DataSource="+@"\SQLMobileDb\MyDatabase#1.sdf;
Pwd=mm3det";
// ConnString = ConnString + "Pwd='mm3det';encrypt database=TRUE";
string selectCmd = "SELECT * FROM list1";
SqlCeConnection conn = new SqlCeConnection(ConnString);
conn.Open();
SqlCeDataAdapter da = new SqlCeDataAdapter(selectCmd, conn);
DataSet ds = new DataSet();
da.Fill(ds, "list1");
GlobalDS = ds;
dataGrid1.DataSource = ds.Tables["list1"];
conn.Close();
da.Dispose();
}
private void Form1_Load(object sender, EventArgs e)
{
SqlCeConnection SqlCeConn = new SqlCeConnection();
}
private void button2_Click(object sender, EventArgs e)
{
}
}
}