Windows Mobile5.0 10月09日笔记：SQLServer CE

1、添加连接->更改->Microsoft Sql server Mobile Edition

                   ->创建->数据库名

2、 添加数据源->数据库->选择数据库.sdf

3、托拽数据源中的表到窗体,将自动产生TableAdapter,DataSet,DataGird,并且自动调用this.customersTableAdapter.Fill(this.hCDateDataSet.Customers);填充数据集

4、通过SqlCeConnection连接数据库

private string connstring;

private SqlCeConnection conn = null

connstring = "Data Source ="
                        + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "//HCDate.sdf;");//应用程序当前路径+数据库名

conn = new SqlCeConnection(connstring);

conn.Open();

5、数据库插入操作

            try
            {
                //方法一
                /*cmd = conn.CreateCommand();
                cmd.CommandText = @"insert into Customers(Name,Sex,Address,Tel)
                    Values('"+ txbName.Text + "','" + txbSex.Text + "','" + txbAddress.Text + "','" + txbTel.Text + "')";*/

                //方法二
                /*string sqlstr = @"insert into Customers(Name,Sex,Address,Tel)
                    Values(@Name,@Sex,@Address,@Tel)";

                cmd = new SqlCeCommand(sqlstr, conn);

                cmd.Parameters.Add(new SqlCeParameter("@Name", SqlDbType.NVarChar, 100));
                cmd.Parameters["@Name"].Value = txbName.Text;

                cmd.Parameters.Add(new SqlCeParameter("@Sex", SqlDbType.NVarChar, 100));
                cmd.Parameters["@Sex"].Value = txbSex.Text;

                cmd.Parameters.Add(new SqlCeParameter("@Address", SqlDbType.NVarChar, 100));
                cmd.Parameters["@Address"].Value = txbAddress.Text;

                cmd.Parameters.Add(new SqlCeParameter("@Tel", SqlDbType.NVarChar, 100));
                cmd.Parameters["@Tel"].Value = txbTel.Text;*/

                //方法三
                string sqlstr = @"insert into Customers(Name,Sex,Address,Tel)
                    Values('" + txbName.Text + "','" + txbSex.Text + "','" + txbAddress.Text + "','" + txbTel.Text + "')";

                cmd = new SqlCeCommand(sqlstr,conn);

                try
                {
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("添加成功！");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }