mobil数据查询和插入

            string str = "data source=" + System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "//1111.sdf;Password=111111;";
            SqlCeConnection cn = new SqlCeConnection(str);
            SqlCeCommand comm = new SqlCeCommand("insert into [User] ([ID],[Name]) values ('zzl44840345','zzl44840345')", cn);
            cn.Open();
            SqlCeDataReader DR = comm.ExecuteReader();
            DR.Close();
            cn.Close();
//--------------------------------------------------------------------------------------------------------
            DataTable dt=new DataTable();
            SqlCeDataAdapter da = new SqlCeDataAdapter("select * from [User]", cn);
            da.Fill(dt);
            cn.Close();
            int i = dt.Rows.Count;
            string k =dt.Rows[0].ItemArray[0].ToString();
            k = dt.Rows[1].ItemArray[0].ToString();