第六章 移动数据的处理.pptVIP

第六章 移动数据的处理 6.1 如何建立数据库 先添加数据连接如图 然后选择更改 接着按确定，如果密码过于简单会提示你是否继续使用 建好后，在服务器资源管理器里出现数据库如下如 6.2 数据库的使用 查询数据库 listView1.Items.Clear(); ??????????? string connectionString = Data Source=\\Program Files\\TestDBOfSdf\\EMS.sdfassword=ems; ??????????? SqlCeConnection cn = new SqlCeConnection(connectionString); ??????????? cn.Open(); ??????????? string sql = select * from oprInfo; ??????????? SqlCeCommand com = new SqlCeCommand(sql, cn); ??????????? SqlCeDataReader read = com.ExecuteReader(); ??????????? while (read.Read()) ??????????? { ??????????????? string custid = read[0].ToString(); ??????????????? string company = read[1].ToString(); ??????????????? string custname = read[2].ToString(); ??????????????? listView1.BeginUpdate(); ??????????????? ListViewItem Item = new ListViewItem(); ??????????????? Item.SubItems[0].Text = custid; ??????????????? Item.SubItems.Add(company); ??????????????? Item.SubItems.Add(custname); ??????????????? listView1.Items.Add(Item); ??????????????? listView1.EndUpdate(); ??????????? } ??????????? read.Close(); ??????????? com.Dispose(); ??????????? cn.Close();  插入记录 string oprid = textBox1.Text.Trim(); ??????????? string oprname = textBox2.Text.Trim(); ??????????? string password = textBox3.Text.Trim(); ??????????? if ((oprid != ) (oprname != ) (password!=)) ??????????? { ??????????????? string connectionString = Data Source=\\Program Files\\TestDBOfSdf\\EMS.sdfassword=ems; ??????????????? try ??????????????? { ??????????????????? SqlCeConnection cn = new SqlCeConnection(connectionString); ??????????????????? cn.Open(); ??????????????????? string sql = insert into oprInfo values(+oprid+,+oprname+,+password+); ??????????????????? SqlCeCommand com = new SqlCeCommand(sql, cn); ??????????????????? com.ExecuteNonQuery(); ??????????????????? com.Dispose(); ??????????????????? cn.Close(); ??????????????????? label4.Text = 操作成功!; ??????????????? } ??????????????? catch (Exception exp) ????????????