Code
string sFilePath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + """xxx.sdf";

         //连接sql server Mobile数据库的连接字符串

            string ConnStr = "Data Source=" + sFilePath + ";Persist Security Info=False;password=test;";

         //建立链接

            ConnMobile = new SqlCeConnection(ConnStr);

            try

            {

                ConnMobile.Open();

            }

            catch (Exception ex)

            {

                MessageBox.Show("不能正确连接移动数据库！" + ex.Message);

                this.Close();

            }

            command = new SqlCeCommand();

            command.Connection = ConnMobile;

            string sqlstr = "select * from Info where IsUP='1'";

            command.CommandText = sqlstr ;

            SqlCeDataReader rs = command.ExecuteReader();