当前位置: 首页>>代码示例>>C#>>正文


C# SqlCeCommand类代码示例

本文整理汇总了C#中SqlCeCommand的典型用法代码示例。如果您正苦于以下问题:C# SqlCeCommand类的具体用法?C# SqlCeCommand怎么用?C# SqlCeCommand使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。


SqlCeCommand类属于命名空间,在下文中一共展示了SqlCeCommand类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: CreateDB

        /// <summary>
        /// Create the initial database
        /// </summary>
        private void CreateDB()
        {
            var connection = new SqlCeConnection(this.path);

            try
            {
                var eng = new SqlCeEngine(this.path);
                var cleanup = new System.Threading.Tasks.Task(eng.Dispose);
                eng.CreateDatabase();
                cleanup.Start();
            }
            catch (Exception e)
            {
                EventLogging.WriteError(e);
            }

            connection.Open();
            var usersDB =
                new SqlCeCommand(
                    "CREATE TABLE Users_DB("
                    + "UserID int IDENTITY (100,1) NOT NULL UNIQUE, "
                    + "UserName nvarchar(128) NOT NULL UNIQUE, "
                    + "PassHash nvarchar(128) NOT NULL, "
                    + "Friends varbinary(5000), "
                    + "PRIMARY KEY (UserID));",
                    connection);
            usersDB.ExecuteNonQuery();
            usersDB.Dispose();
            connection.Dispose();
            connection.Close();
        }
开发者ID:novaksam,项目名称:CIS499_C-_IM_Package,代码行数:34,代码来源:DBInteract.cs

示例2: DropData

 static void DropData(SqlCeConnection connection)
 {
     Console.Write("Dropping");
     Console.CursorLeft = 0;
     SqlCeCommand command = new SqlCeCommand("delete from entity", connection);
     command.ExecuteNonQuery();
 }
开发者ID:rickertDevel,项目名称:ballin-nemesis,代码行数:7,代码来源:Program.cs

示例3: CreateInitialDatabaseObjects

        private static void CreateInitialDatabaseObjects(string connString)
        {
            using (SqlCeConnection conn = new SqlCeConnection(connString))
            {
                string[] queries = Regex.Split(NetworkAssetManager.Properties.Resources.DBGenerateSql, "GO");
                SqlCeCommand command = new SqlCeCommand();
                command.Connection = conn;
                conn.Open();
                foreach (string query in queries)
                {
                    string tempQuery = string.Empty;
                    tempQuery = query.Replace("\r\n", "");

                    if (tempQuery.StartsWith("--") == true)
                    {
                        /*Comments in script so ignore*/
                        continue;
                    }

                    _logger.Info("Executing query: " + tempQuery);

                    command.CommandText = tempQuery;
                    try
                    {
                        command.ExecuteNonQuery();
                    }
                    catch (System.Exception e)
                    {
                        _logger.Error(e.Message);
                    }
                }
                conn.Close();
            }
        }
开发者ID:5dollartools,项目名称:NAM,代码行数:34,代码来源:CreateDatabase.cs

示例4: Carregar

        //Chamar sempre apos carregar os parametros
        public void Carregar()
        {
            SqlCeDataReader reader=null;
            try
            {
                string sql = "select * from funcionario where id=" + Id;
                SqlCeCommand cmd = new SqlCeCommand(sql, D.Bd.Con);
                reader = cmd.ExecuteReader();
                reader.Read();

                Nome = Convert.ToString(reader["nome"]);
                DescontoMaximo = Convert.ToDouble(reader["desconto_maximo"]);
                AcrescimoMaximo = Convert.ToDouble(reader["acrescimo_maximo"]);
            }
            catch (Exception ex)
            {
                throw new Exception("Não consegui obter os dados do funcionário, configure e sincronize antes de utilizar o dispositivo " + ex.Message);
            }
            finally
            {
                try
                {
                    reader.Close();
                }
                catch { }
            }
        }
开发者ID:evandrojr,项目名称:NeoPocket,代码行数:28,代码来源:Funcionario.cs

示例5: InitTestSchema

        public void InitTestSchema()
        {
            var connStr = String.Format("Data Source = '{0}';", _testDb);
            using (var conn = new SqlCeConnection(connStr))
            {
                conn.Open();
                var command = new SqlCeCommand();
                command.Connection = conn;
                command.CommandText =
                    @"CREATE TABLE accel_data (
                                     id INT IDENTITY NOT NULL PRIMARY KEY,
                                     date DATETIME,
                                     Ax Float,Ay Float
                                     )";
                command.ExecuteNonQuery();

                command.CommandText = @"CREATE TABLE accel_params (
                                         id INT IDENTITY NOT NULL PRIMARY KEY,
                                         date DATETIME,
                                         sensorNumber smallint,
                                         offsetX Float,offsetY Float,
                                         gravityX Float,gravityY Float
                                     )";
                command.ExecuteNonQuery();

                command.CommandText = @"CREATE TABLE calibr_result (
                                         id INT IDENTITY NOT NULL PRIMARY KEY,
                                         accelDataId INT,
                                         accelParamsId INT
                                     )";
                command.ExecuteNonQuery();
            }
        }
开发者ID:pengwin,项目名称:AccelLib,代码行数:33,代码来源:TestDatabaseStub.cs

示例6: ModuleMainForm

        public ModuleMainForm()
        {
            InitializeComponent();
            try
            {
                // make data folder for this module
                Common.MakeAllSubFolders(Static.DataFolderPath);
                // check sdf database file, and copy new if dont exists
                Static.CheckDB_SDF();

                conn = new SqlCeConnection(Static.ConnectionString);
                command = new SqlCeCommand("", conn);
                dgwPanel.Columns.Add("tag", "Tag");
                dgwPanel.Columns.Add("info", "Info");
                DataGridViewButtonColumn btnColl1 = new DataGridViewButtonColumn();
                btnColl1.HeaderText = "Edit";
                btnColl1.Name = "Edit";
                dgwPanel.Columns.Add(btnColl1);
                keyEventsArgs = new KeyEventArgs(Keys.Oemtilde | Keys.Control);
                HookManager.KeyDown += new KeyEventHandler(HookManager_KeyDown);
            }
            catch (Exception exc)
            {
                Log.Write(exc, this.Name, "ModuleMainForm", Log.LogType.ERROR);
            }
        }
开发者ID:dmarijanovic,项目名称:uber-tools,代码行数:26,代码来源:ModuleMainForm.cs

示例7: getAppointmentList

 public List<Appointment> getAppointmentList()
 {
     List<Appointment> AppointmentList = new List<Appointment>();
     SqlCeCommand cmd = new SqlCeCommand("select * from Appointment " +
                                         "inner join RoomInformation on Appointment.RoomID = RoomInformation.RoomID " +
                                         "inner join UserInformation on Appointment.UserID = UserInformation.User_ID " +
                                         "inner join UserInformation as RoomAccount on RoomInformation.UserID = RoomAccount.User_ID " +
                                         "where Appointment.RoomID = @RoomID and Appointment.UserID = @UserID", conn);
     cmd.Parameters.AddWithValue("@UserID", this._appointment.UserID);
     cmd.Parameters.AddWithValue("@RoomID", this._appointment.RoomID);
     SqlCeDataAdapter adapter = new SqlCeDataAdapter();
     adapter.SelectCommand = cmd;
     DataSet setdata = new DataSet();
     adapter.Fill(setdata, "Appointment");
     for (int i = 0; i < setdata.Tables[0].Rows.Count; i++)
     {
         Appointment model = new Appointment();
         model.AppointmentID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[0].ToString());
         model.RoomID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[1].ToString());
         model.UserID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[2].ToString());
         model.AppointmentDate = DateTime.Parse(setdata.Tables[0].Rows[i].ItemArray[3].ToString());
         model.Status = setdata.Tables[0].Rows[i].ItemArray[4].ToString();
         model.Respond = setdata.Tables[0].Rows[i].ItemArray[5].ToString();
         model.RoomAcc.RoomID = Int64.Parse(setdata.Tables[0].Rows[i].ItemArray[1].ToString());
         model.RoomAcc.ApartmentName = setdata.Tables[0].Rows[i].ItemArray[7].ToString();
         model.RoomAcc.RoomForSale = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[8].ToString());
         model.RoomAcc.RoomForRent = bool.Parse(setdata.Tables[0].Rows[0].ItemArray[9].ToString());
         model.Appointee = setdata.Tables[0].Rows[i].ItemArray[49].ToString();
         model.RoomAcc.Username = setdata.Tables[0].Rows[i].ItemArray[62].ToString();
         AppointmentList.Add(model);
     }
     return AppointmentList;
 }
开发者ID:udgarpiya,项目名称:AU_SeniorProject,代码行数:33,代码来源:AppointmentRepository.cs

示例8: InsertCapturePointsForTextConversion

        public static int InsertCapturePointsForTextConversion(int RecommendationId, List<CustomTreeNode> customNodesList)
        {
            int returnCode = -1;
            List<int> capturePointsIds = new List<int>();
            SqlCeConnection conn = BackEndUtils.GetSqlConnection();
            try {
                conn.Open();
                for (int i = 0; i < customNodesList.Count; i++) {
                    SqlCeCommand command = new SqlCeCommand(Rec_CapturePoints_TextConv_SQL.commandInsertCapturePointTextConv, conn);
                    //@pointText, @pointUsedAttributes, @pointParentNode, @pointUsedAttribValues, @pointRecId
                    command.Parameters.Add("@pointText", customNodesList[i].Text);
                    command.Parameters.Add("@pointUsedAttributes", BackEndUtils.GetUsedAttributes(customNodesList[i].customizedAttributeCollection));
                    command.Parameters.Add("@pointParentNode", (customNodesList[i].Parent == null ? "" : customNodesList[i].Parent.Text));
                    command.Parameters.Add("@pointUsedAttribValues", BackEndUtils.GetUsedAttributesValues(customNodesList[i].customizedAttributeCollection));
                    command.Parameters.Add("@pointRecId", RecommendationId);
                    command.Parameters.Add("@Level", customNodesList[i].Level);
                    command.Parameters.Add("@ItemIndex", customNodesList[i].Index);
                    command.Parameters.Add("@parentLevel", customNodesList[i].Parent == null ? -1 : customNodesList[i].Parent.Level);
                    command.Parameters.Add("@parentIndex", customNodesList[i].Parent == null ? -1 : customNodesList[i].Parent.Index);

                    returnCode = Convert.ToInt32(command.ExecuteNonQuery());
                    SqlCeCommand commandMaxId = new SqlCeCommand(Rec_CapturePoints_TextConv_SQL.commandMaxCapturePointIdTextConv, conn);
                    capturePointsIds.Add(Convert.ToInt32(commandMaxId.ExecuteScalar()));
                }
            } finally {
                conn.Close();
            }
            return returnCode;
        }
开发者ID:mzkabbani,项目名称:XMLParser,代码行数:29,代码来源:Rec_CapturePoints_TextConv.cs

示例9: CrearConexion

        //AñadirPago
        public void AñadirNuevo(PagoEntrante pagEntr)
        {
            //Crear Conexion y Abrirla
            SqlCeConnection Con = CrearConexion();

            // Crear SQLCeCommand - Asignarle la conexion - Asignarle la instruccion SQL (consulta)
            SqlCeCommand Comando = new SqlCeCommand();
            Comando.Connection = Con;
            Comando.CommandType = CommandType.Text;

            Comando.CommandText = "INSERT INTO [PagosEntrantes] ([idTramite], [dniCuilCliente], [fecha], [valor], [detalle]) VALUES (@IDTRAMITE, @DNICUILCLI, @FECHA, @VALOR, @DETALLE)";
            Comando.Parameters.Add(new SqlCeParameter("@IDTRAMITE", SqlDbType.Int));
            Comando.Parameters["@IDTRAMITE"].Value = pagEntr.IdTramite;
            Comando.Parameters.Add(new SqlCeParameter("@DNICUILCLI", SqlDbType.NVarChar));
            Comando.Parameters["@DNICUILCLI"].Value = pagEntr.DniCuilCliente;
            Comando.Parameters.Add(new SqlCeParameter("@FECHA", SqlDbType.DateTime));
            Comando.Parameters["@FECHA"].Value = pagEntr.Fecha;
            Comando.Parameters.Add(new SqlCeParameter("@VALOR", SqlDbType.Money));
            Comando.Parameters["@VALOR"].Value = pagEntr.Valor;
            Comando.Parameters.Add(new SqlCeParameter("@DETALLE", SqlDbType.NVarChar));
            Comando.Parameters["@DETALLE"].Value = pagEntr.Detalle;

            //Ejecuta el comando INSERT
            Comando.Connection.Open();
            Comando.ExecuteNonQuery();
            Comando.Connection.Close();
        }
开发者ID:dantearrighi,项目名称:WASSDiploma,代码行数:28,代码来源:PagosEntrantesAdapter.cs

示例10: CreateUser

        public static User CreateUser(string username, string password)
        {
            SqlCeConnection con = new SqlCeConnection(CONNECTION_STRING);
            try
            {
                con.Open();
                SqlCeCommand comm = new SqlCeCommand("INSERT INTO users (username, password, salt, dateCreated) VALUES (@username, @password, @salt, @createdDate)", con);
                comm.Parameters.Add(new SqlCeParameter("@username", username));
                comm.Parameters.Add(new SqlCeParameter("@password", password));
                comm.Parameters.Add(new SqlCeParameter("@salt", String.Empty));
                comm.Parameters.Add(new SqlCeParameter("@createdDate", DateTime.UtcNow));

                int numberOfRows = comm.ExecuteNonQuery();
                if (numberOfRows > 0)
                {
                    return GetUser(username);
                }
            }
            catch (Exception ex)
            {
                Debug.Print("CreateUser Exception: " + ex);
            }
            finally
            {
                if (con != null && con.State == ConnectionState.Open)
                {
                    con.Close();
                }
            }

            return null;
        }
开发者ID:reedyrm,项目名称:am_backend,代码行数:32,代码来源:UserDataService.cs

示例11: ApplicationState

        private ApplicationState()
        {
            // read the application state from db
            SqlCeConnection _dataConn = null;
            try
            {
                _dataConn = new SqlCeConnection("Data Source=FlightPlannerDB.sdf;Persist Security Info=False;");
                _dataConn.Open();
                SqlCeCommand selectCmd = new SqlCeCommand();
                selectCmd.Connection = _dataConn;
                StringBuilder selectQuery = new StringBuilder();
                selectQuery.Append("SELECT cruiseSpeed,cruiseFuelFlow,minFuel,speed,unit,utcOffset,locationFormat,deckHoldFuel,registeredClientName FROM ApplicationState");
                selectCmd.CommandText = selectQuery.ToString();
                SqlCeResultSet results = selectCmd.ExecuteResultSet(ResultSetOptions.Scrollable);
                if (results.HasRows)
                {
                    results.ReadFirst();
                    cruiseSpeed = results.GetInt64(0);
                    cruiseFuelFlow = results.GetInt64(1);
                    minFuel = results.GetInt64(2);
                    speed = results.GetSqlString(3).ToString();
                    unit = results.GetSqlString(4).ToString();
                    utcOffset = results.GetSqlString(5).ToString();
                    locationFormat = results.GetSqlString(6).ToString();
                    deckHoldFuel = results.IsDBNull(7) ? 0 : results.GetInt64(7);
                    registeredClientName = results.IsDBNull(8) ? string.Empty : results.GetString(8);
                }

            }

            finally
            {
                _dataConn.Close();
            }
        }
开发者ID:hrishi18pathak,项目名称:QNP,代码行数:35,代码来源:ApplicationState.cs

示例12: DeleteAllFileNames

 public static void DeleteAllFileNames(SqlCeTransaction transaction, SqlCeConnection conn)
 {
     SqlCeCommand command = new SqlCeCommand(Folder_Names_SQL.commandDeleteAllFolderNames, conn);
     command.Transaction = transaction;
     command.Connection = conn;
     command.ExecuteNonQuery();
 }
开发者ID:mzkabbani,项目名称:cSharpProjects,代码行数:7,代码来源:Folder_Names.cs

示例13: button1_Click

        //Search button clicked
        private void button1_Click(object sender, EventArgs e)
        {
            SqlCeCommand cm = new SqlCeCommand();
            if (comboBox1.Text.Length < 1)
            {
                cm = new SqlCeCommand("SELECT ID, Marka as Brand, Tipus as Type, Kiadasi_ev as R_year, Berlesi_ar as Price  FROM Autok WHERE Allapot='raktaron' AND Kiadasi_ev>@yearfrom AND Kiadasi_ev<@yearuntil AND Eladasi_ar>@pricefrom AND Eladasi_ar<@priceuntil", Form1.con);
            }
            else if (comboBox2.Text.Length < 1)
            {
                cm = new SqlCeCommand("SELECT ID, Marka as Brand, Tipus as Type, Kiadasi_ev as R_year, Berlesi_ar as Price FROM Autok  WHERE Allapot='raktaron' AND [email protected]  AND Kiadasi_ev>@yearfrom AND Kiadasi_ev<@yearuntil AND Eladasi_ar>@pricefrom AND Eladasi_ar<@priceuntil ", Form1.con);
            }
            else
            {
                cm = new SqlCeCommand("SELECT ID, Marka as Brand, Tipus as Type, Kiadasi_ev as R_yer, Berlesi_ar as Price FROM Autok WHERE Allapot='raktaron' AND [email protected] AND [email protected]  AND Kiadasi_ev>@yearfrom AND Kiadasi_ev<@yearuntil AND Eladasi_ar>@pricefrom AND Eladasi_ar<@priceuntil ", Form1.con);
            }
            if (comboBox6.Text.Equals("100000+"))
            {
                cm.Parameters.AddWithValue("@priceuntil", int.MaxValue);
            }
            else
            {
                cm.Parameters.AddWithValue("@priceuntil", comboBox6.Text);
            }
            cm.Parameters.AddWithValue("@pricefrom", comboBox4.Text);
            cm.Parameters.AddWithValue("@yearuntil", comboBox5.Text);
            cm.Parameters.AddWithValue("@yearfrom", comboBox3.Text);
            cm.Parameters.AddWithValue("@tipus", comboBox2.Text);
            cm.Parameters.AddWithValue("@marka", comboBox1.Text);
            SqlCeDataAdapter a = new SqlCeDataAdapter(cm);
            DataTable dt = new DataTable();
            a.Fill(dt);

            dataGridView2.DataSource = dt;
            this.dataGridView2.Height = setAutomaticHeight(this.dataGridView2.Columns[0].HeaderCell.Size.Height, this.dataGridView2.Rows[0].Height, this.dataGridView2.Rows.Count, 340);
        }
开发者ID:Ernyoke,项目名称:CarRent,代码行数:36,代码来源:Rent.cs

示例14: Save

		internal void Save()
		{
			const string updateSql = @"update Creating set
ExcludeFilesOfType = @ExcludeFilesOfType,
SortFiles = @SortFiles,
SFV32Compatibility = @SFV32Compatibility,
MD5SumCompatibility = @MD5SumCompatibility,
PromptForFileName = @PromptForFileName,
AutoCloseWhenDoneCreating = @AutoCloseWhenDoneCreating,
CreateForEachSubDir = @CreateForEachSubDir
";

			using (SqlCeCommand cmd = new SqlCeCommand(updateSql, Program.GetOpenSettingsConnection()))
			{
				cmd.Parameters.AddWithValue("@ExcludeFilesOfType", ExcludeFilesOfType);
				cmd.Parameters.AddWithValue("@SortFiles", SortFiles);
				cmd.Parameters.AddWithValue("@SFV32Compatibility", SFV32Compatibility);
				cmd.Parameters.AddWithValue("@MD5SumCompatibility", MD5SumCompatibility);
				cmd.Parameters.AddWithValue("@PromptForFileName", PromptForFileName);
				cmd.Parameters.AddWithValue("@AutoCloseWhenDoneCreating", AutoCloseWhenDoneCreating);
				cmd.Parameters.AddWithValue("@CreateForEachSubDir", CreateForEachSubDir);

				cmd.ExecuteNonQuery();
			}
		}
开发者ID:neurocache,项目名称:ilSFV,代码行数:25,代码来源:CreateSettings.cs

示例15: connectToDatabase

        public void connectToDatabase()
        {
            mySqlConnection = new SqlCeConnection(@"Data Source=C:\University\Adv Software Engineering\Bug Tracker\BugTracker\BugTracker\BugDatabase.mdf");
            String selcmd = "SELECT BugID, LineStart, LineEnd, ProgrammerName, ClassName, MethodName, TimeSubmitted, ProjectName, Description FROM dbo ORDER BY TimeSubmitted";
            SqlCeCommand mySqlCommand = new SqlCeCommand(selcmd, mySqlConnection);

        }
开发者ID:MastaN81985,项目名称:BugTracker,代码行数:7,代码来源:Form1.cs


注:本文中的SqlCeCommand类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。