SQLCE （含数据文件无需安装SQL server）

城市联动

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 SelCity
{
    public partial class Form1 : Form
    {

        private static string ConnectionString = “Data Source=\\FlashDisk\\basedata.sdf;password=‘zjs‘;“;
  

        public Form1（）
        {
            InitializeComponent（）;

        }

        private void Form1_Load（object sender EventArgs e）
        {

            SqlCeConnection conn;
            SqlCeCommand cmd;
            string cmdstring = “select Province from Province “;
            conn = new SqlCeConnection（ConnectionString）;
            cmd = new SqlCeCommand（cmdstring conn）;

    

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2010-07-20 14:28  SDF数据库测试\
     目录           0  2010-07-20 14:28  SDF数据库测试\SelCity\
     目录           0  2010-06-03 15:04  SDF数据库测试\SelCity\SelCity\
     文件        1076  2010-07-20 14:28  SDF数据库测试\SelCity\SelCity.sln
     文件       10240  2010-07-20 14:28  SDF数据库测试\SelCity\SelCity.suo
     目录           0  2010-06-03 13:47  SDF数据库测试\SelCity\SelCity\bin\
     目录           0  2010-06-03 10:47  SDF数据库测试\SelCity\SelCity\bin\Debug\
     文件        8704  2010-06-03 13:29  SDF数据库测试\SelCity\SelCity\bin\Debug\SelCity.exe
     文件       22016  2010-06-03 13:29  SDF数据库测试\SelCity\SelCity\bin\Debug\SelCity.pdb
     文件      228112  2005-09-03 06:55  SDF数据库测试\SelCity\SelCity\bin\Debug\System.Data.SqlServerCe.dll
     文件      197131  2005-07-15 22:35  SDF数据库测试\SelCity\SelCity\bin\Debug\System.Data.SqlServerCe.xml
     目录           0  2010-06-03 10:44  SDF数据库测试\SelCity\SelCity\bin\Release\
     文件        9216  2010-06-03 15:04  SDF数据库测试\SelCity\SelCity\bin\Release\SelCity.exe
     文件       22016  2010-06-03 15:04  SDF数据库测试\SelCity\SelCity\bin\Release\SelCity.pdb
     文件      228112  2005-09-03 06:55  SDF数据库测试\SelCity\SelCity\bin\Release\System.Data.SqlServerCe.dll
     文件      197131  2005-07-15 22:35  SDF数据库测试\SelCity\SelCity\bin\Release\System.Data.SqlServerCe.xml
     文件        4069  2010-06-03 15:04  SDF数据库测试\SelCity\SelCity\Form1.cs
     文件        4711  2010-06-03 14:05  SDF数据库测试\SelCity\SelCity\Form1.Designer.cs
     文件        6101  2010-06-03 14:05  SDF数据库测试\SelCity\SelCity\Form1.resx
     目录           0  2010-06-03 10:44  SDF数据库测试\SelCity\SelCity\obj\
     目录           0  2010-06-03 13:29  SDF数据库测试\SelCity\SelCity\obj\Debug\
     文件         842  2010-06-03 12:59  SDF数据库测试\SelCity\SelCity\obj\Debug\SelCity.csproj.GenerateResource.Cache
     文件        8704  2010-06-03 13:29  SDF数据库测试\SelCity\SelCity\obj\Debug\SelCity.exe
     文件         180  2010-06-03 12:59  SDF数据库测试\SelCity\SelCity\obj\Debug\SelCity.Form1.resources
     文件       22016  2010-06-03 13:29  SDF数据库测试\SelCity\SelCity\obj\Debug\SelCity.pdb
     文件         180  2010-06-03 10:47  SDF数据库测试\SelCity\SelCity\obj\Debug\SelCity.Properties.Resources.resources
     目录           0  2010-06-03 10:44  SDF数据库测试\SelCity\SelCity\obj\Debug\TempPE\
     目录           0  2010-06-03 15:04  SDF数据库测试\SelCity\SelCity\obj\Release\
     文件        8958  2010-06-03 13:57  SDF数据库测试\SelCity\SelCity\obj\Release\ResolveAssemblyReference.cache
     文件         842  2010-06-03 14:05  SDF数据库测试\SelCity\SelCity\obj\Release\SelCity.csproj.GenerateResource.Cache
     文件        9216  2010-06-03 15:04  SDF数据库测试\SelCity\SelCity\obj\Release\SelCity.exe
............此处省略14个文件信息