现在在这里和大家分享一下。

windows mobile 访问本地数据有3种方法。分别是 ADO.NET   SQL Mobile   XML .

这里我给大家讲解 《如何利用 SQL Mobile 访问本地数据》。

好了 不说废话了。

先看代码：

 

----------------------------------------------------------------------------------

private void main_Load(object sender, EventArgs e)
        {
            try
            {
                System.IO.File.Delete("\\My Documents\\db.sdf");
                System.Data.SqlServerCe.SqlCeEngine SQLengine = new System.Data.SqlServerCe.SqlCeEngine("data source=\\My Documents\\db.sdf");
                SQLengine.CreateDatabase();

                System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection("Data Source=\\My Documents\\db.sdf");
                cn.Open();

                String sql = "create table userinfo (userid nchar(5) primary key"
                           + " not null,username nvarchar(40) not null,userpass nvarchar(40) not null)";
                System.Data.SqlServerCe.SqlCeCommand cmd = new System.Data.SqlServerCe.SqlCeCommand(sql, cn);
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
                sql = "";

                sql = "insert into userinfo (userid,username,userpass) values "
                   + "('1','admin','admin')";

                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
            catch(Exception  ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

以上代码的意思是创建一个名为 DB 的数据库，扩展名为 .sdf 。这是一个文件型数据库。

-----------------------------------------------------------------------------------

try
            {
                System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection("Data Source=\\My Documents\\db.sdf");
                cn.Open();

                System.Data.SqlServerCe.SqlCeCommand cmd = cn.CreateCommand();
                cmd.CommandText = "select username from userinfo";
                System.Data.SqlServerCe.SqlCeDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    MessageBox.Show(reader.GetString(0));
                }
               

            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.ToString());
           
            }

以上代码是读取数据。

-------------------------------------------------------------------------------

System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection("Data Source=\\My Documents\\db.sdf");
                    cn.Open();

                    String sql = "insert into userinfo (userid,username,userpass) values (2,'" + this.txtname.Text + "','" + this.txtpass.Text + "')";
                    System.Data.SqlServerCe.SqlCeCommand cmd = new System.Data.SqlServerCe.SqlCeCommand(sql, cn);
                    cmd.CommandType = CommandType.Text;
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("data inserted");

以上是在userinfo表中插入一条记录。

---------------------------------------------------------------------------------

 

 

 

好了今天就给大家介绍这么多了。以后会及时更新。

大家可以给我留言。