C# SQLite.SQLiteParameter类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

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

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

示例1: AddRili

        public int AddRili(Rili rili)
        {
            int result = 0;
            try
            {
                string sql = "INSERT INTO t_rili(Yangli,Nongli,Zhigan,Xingzuo,Xingqi,Yi,Ji)values(@Yangli,@Nongli,@Zhigan,@Xingzuo,@Xingqi,@Yi,@Ji)";

                SQLiteParameter[] parameters = new SQLiteParameter[]{
                                         new SQLiteParameter("@Yangli",rili.Yangli),
                                         new SQLiteParameter("@Nongli",rili.Nongli),
                                         new SQLiteParameter("@Zhigan",rili.Zhigan),
                                         new SQLiteParameter("@Xingzuo",rili.Xingzuo),
                                         new SQLiteParameter("@Xingqi",rili.Xingqi),
                                         new SQLiteParameter("@Yi",rili.Yi),
                                         new SQLiteParameter("@Ji",rili.Ji)
                                         };
                SqlAction action = new SqlAction();
                result = action.IntQuery(sql, parameters);
            }
            catch (Exception ex)
            {
                Log.Error("插入日历数据出错：" + ex.ToString());
            }
            return result;
        }

开发者ID:JimmyFung，项目名称:DesktopHelper，代码行数:25，代码来源:DataManipulation.cs

示例2: ExecuteNonQuery

 /// <summary> 
 /// 对SQLite数据库执行增删改操作，返回受影响的行数。 
 /// </summary> 
 /// <param name="sql">要执行的增删改的SQL语句</param> 
 /// <param name="parameters">执行增删改语句所需要的参数，参数必须以它们在SQL语句中的顺序为准</param> 
 /// <returns></returns> 
 public int ExecuteNonQuery(string sql, SQLiteParameter[] parameters)
 {
     int affectedRows = 0;
     try
     {
         using (SQLiteConnection connection = new SQLiteConnection(connectionString))
         {
             connection.Open();
             using (DbTransaction transaction = connection.BeginTransaction())
             {
                 using (SQLiteCommand command = new SQLiteCommand(connection))
                 {
                     command.CommandText = sql;
                     if (parameters != null)
                     {
                         command.Parameters.AddRange(parameters);
                     }
                     affectedRows = command.ExecuteNonQuery();
                 }
                 transaction.Commit();
             }
         }
     }
     catch
     { }
     return affectedRows;
 }

开发者ID:JimmyFung，项目名称:DesktopHelper，代码行数:33，代码来源:UpdateDBHelper.cs

示例3: GetUsers

        public List<UserEntity> GetUsers(int skip, int pagesize, string userName, out int count)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append(" select Uid,Name,Photo,RolesIds,Status from t_users ");

            if (!string.IsNullOrEmpty(userName))
            {
                sql.Append(" where Uid like @Uid ");
            }
            if (pagesize != 0)
            {
                sql.Append(" Limit @count Offset @skip ");

            }


            SQLiteParameter[] para = new SQLiteParameter[] {
                new SQLiteParameter("@count", pagesize),
                new SQLiteParameter("@skip", skip),
                new SQLiteParameter("@Uid", "%"+userName+"%")
            };
            SqlLiteHelper sqliteHelper = new SqlLiteHelper();
            DataTable dataTable = sqliteHelper.GetDataTable(sql.ToString(), para);
            List<UserEntity> userEntities = new List<UserEntity>();
            foreach (DataRow dataRow in dataTable.Rows)
            {
                userEntities.Add(Conver2Entity(dataRow));
            }
            count = sqliteHelper.GetCount("t_users");
            return userEntities;
        }

开发者ID:PerryPal，项目名称:Huber.net，代码行数:31，代码来源:UserDal.cs

示例4: Main

        static void Main(string[] args)
        {
            // On crée nos variables:
            SQLiteConnection connection = new SQLiteConnection();
            
            // Disponible sur le site http://www.connectionstrings.com
            // "Data Source=filename;Version=3;"        
            connection.ConnectionString = "Data Source=test.db;Version=3";
            // Il serait bien sûr possible d'en faire plus, par exemple, mot de passe, mais on va s'en tenir à ça.

            // Ouvre la connexion à la base de donnée
            connection.Open();


            // À présent, il faut se rappeler le SQL que nous avons appris pendant les cours de base de donneés:
            // Créons donc nos tables:

            SQLiteCommand command = new SQLiteCommand("DROP TABLE IF EXISTS Étudiants; CREATE TABLE Étudiants(" +
                " ID integer Primary Key, " +
                " Nom string, " +
                " Prenom string, " +
                " DateDeNaissance date, " +
                " Ville string, " +
                " Technique string, " +
                " NuméroTéléphone string); ");

            command.Connection = connection;
            command.ExecuteNonQuery();

            // Il est possible de faire nos opérations en plus qu'une étape:

            SQLiteCommand command2 = new SQLiteCommand("INSERT INTO Étudiants VALUES ( @ID, @Nom, @Prenom, @DateNaissance, @Ville, @Technique,@No);", connection);
            command2.Parameters.AddWithValue("@ID", null);
            command2.Parameters.AddWithValue("@Nom", "Di Croci");

            SQLiteParameter param3 = new SQLiteParameter("@Prenom");
            param3.Value = "Michel";
            command2.Parameters.Add(param3);

            command2.Parameters.AddWithValue("@DateNaissance", "13/10/1979");
            command2.Parameters.AddWithValue("@Ville", "L'Assomption");
            command2.Parameters.AddWithValue("@Technique", "Informatique");
            command2.Parameters.AddWithValue("@No", "haha!");

            command2.ExecuteNonQuery();

            // Comme vous le constatez, on ne sait pas quel numéro d'enregistrement vient d'être entré...
            // Dans le cas de l'utilisation de clé étrangère (comme dnas notre TP), il peut devenir pratique d'avoir ce numéro
            // dans ce cas, nous devons utiliser select last_insert_rowid

            command.CommandText = "SELECT last_insert_rowid() FROM Étudiants";
            // Comme vous le savez, SELECT nous retourne un élément contrairement à un INSERT ou un UPDATE OU UN DELETE
            // Cela siginifie entre autre que la requête précédente va nous retourner qu'un seul scalaire, sinon nous aurions
            // utilisé le SQLiteDataReader que nous verrons ultérieurement
            object id = command.ExecuteScalar();

            Console.WriteLine(id);

            connection.Close();
        }

开发者ID:drynish，项目名称:ecole，代码行数:60，代码来源:Program.cs

示例5: Login

        public static bool Login(int accountId, string password)
        {
            using (SQLiteConnection con = new SQLiteConnection(Settings.Default.AccountingConnectionString))
            {
                using (SQLiteCommand cmd = new SQLiteCommand())
                {
                    cmd.Connection = con;
                    cmd.CommandText = "SELECT COUNT(accountId) FROM vAccountPassword WHERE accountId = @account AND password = @password";
                    SQLiteParameter pAccount = new SQLiteParameter("account",accountId);
                    pAccount.Direction = ParameterDirection.Input;

                    SQLiteParameter pPassword = new SQLiteParameter("password", password);
                    pPassword.Direction = ParameterDirection.Input;

                    cmd.Parameters.AddRange(new SQLiteParameter[] { pAccount, pPassword });
                    con.Open();
                    if (Convert.ToInt32(cmd.ExecuteScalar()) == 1)
                    {
                        con.Close();
                        return true;
                    }
                    con.Close();
                    return false;
                }
            }
        }

开发者ID:ahtisam，项目名称:HomeAccounting，代码行数:26，代码来源:LoginChecker.cs

示例6: AddPatientBaseInfo

 public long AddPatientBaseInfo(PatientInfo model)
 {
     StringBuilder stringBuilder = new StringBuilder();
     stringBuilder.Append("insert into PatientBaseInfo(");
     stringBuilder.Append("PatientAge,PatientName,PatientSex,BeHospitalizedDate,Bed,CourtyardState,LeaveHospitalDate,LeaveHospitalAgent,Diacrisis)");
     stringBuilder.Append(" values (");
     stringBuilder.Append("@PatientAge,@PatientName,@PatientSex,@BeHospitalizedDate,@Bed,@CourtyardState,@LeaveHospitalDate,@LeaveHospitalAgent,@Diacrisis)");
     stringBuilder.Append(";select LAST_INSERT_ROWID()");
     SQLiteParameter[] array = new SQLiteParameter[]
     {
         new SQLiteParameter("@PatientAge", DbType.Int16),
         new SQLiteParameter("@PatientName", DbType.String),
         new SQLiteParameter("@PatientSex", DbType.String),
         new SQLiteParameter("@BeHospitalizedDate", DbType.Date),
         new SQLiteParameter("@Bed", DbType.String),
         new SQLiteParameter("@CourtyardState", DbType.String),
         new SQLiteParameter("@LeaveHospitalDate", DbType.Date),
         new SQLiteParameter("@LeaveHospitalAgent", DbType.String),
         new SQLiteParameter("@Diacrisis", DbType.String)
     };
     array[0].Value = model.Age;
     array[1].Value = model.Name;
     array[2].Value = model.Sex;
     array[3].Value = model.BeHospitalizedDate;
     array[4].Value = model.Bed;
     array[5].Value = model.CourtyardState;
     array[6].Value = model.LeaveHospitalDate;
     array[7].Value = model.LeaveHospitalAgent;
     array[8].Value = model.Diacrisis;
     object single = DbHelperSQLite.GetSingle(stringBuilder.ToString(), array);
     return Convert.ToInt64(single);
 }

开发者ID:jibie，项目名称:CaseHistory，代码行数:32，代码来源:DataEngine.cs

示例7: ExecuteDataTable

        /// <summary> 
        /// 执行一个查询语句，返回一个包含查询结果的DataTable 
        /// </summary> 
        /// <param name="sql">要执行的查询语句</param> 
        /// <param name="parameters">执行SQL查询语句所需要的参数，参数必须以它们在SQL语句中的顺序为准</param> 
        /// <returns></returns> 
        public int ExecuteDataTable(StringBuilder sql, SQLiteParameter[] parameters, ref DataTable dt)
        {
            try
            {
                using (SQLiteConnection connection = new SQLiteConnection(connectionString))
                {
                    connection.Open();
                    using (SQLiteCommand command = new SQLiteCommand(sql.ToString(), connection))
                    {
                        if (parameters != null)
                        {
                            command.Parameters.AddRange(parameters);
                        }

                        SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
                        adapter.Fill(dt);
                        return 0;
                    }
                }

            }
            catch (Exception ex)
            {
                return -1;
                throw new Exception(ex.Message);
            }
        }

开发者ID:hanxinlei2002，项目名称:LotteryApp，代码行数:33，代码来源:SQLiteDBHelper.cs

示例8: addUser

        // add users to the database
        public bool addUser(string username, string password)
        {
            SQLiteCommand dbcmd = dbcon.CreateCommand();
            string Sql = "INSERT INTO users VALUES (?,?); INSERT INTO scores VALUES (?,?);";
            dbcmd.CommandText = Sql;
            SQLiteParameter param1 = new SQLiteParameter();
            SQLiteParameter param2 = new SQLiteParameter();
            SQLiteParameter param3 = new SQLiteParameter();
            SQLiteParameter param4 = new SQLiteParameter();
            param1.Value = username;
            param2.Value = password;
            param3.Value = username;
            param4.Value = 0;
            dbcmd.Parameters.Add(param1);
            dbcmd.Parameters.Add(param2);
            dbcmd.Parameters.Add(param3);
            dbcmd.Parameters.Add(param4);
            SQLiteDataReader reader = dbcmd.ExecuteReader();

            reader.Close();
            reader = null;
            // dispose of database commands
            dbcmd.Dispose();
            dbcmd = null;

            // should only be called if conditions are right
            // for adding users; always return true
            return true;
        }

开发者ID:jsdodgers，项目名称:ICS168Swarch，代码行数:30，代码来源:SQLiteDB.cs

示例9: AddLoginHistory

 /// <summary>
 /// 添加登录记录
 /// </summary>
 /// <param name="userid"></param>
 /// <returns></returns>
 public static bool AddLoginHistory(Int64 userid)
 {
     string sqlStr = "INSERT INTO LoginHistory(UserID,LoginTime) Values(@USERID,datetime('now','localtime'));";
     SQLiteParameter parameter = new SQLiteParameter("@USERID", System.Data.DbType.Int64);
     parameter.Value = userid;
     return ExecuteNonQuery(sqlStr, parameter) > 0;
 }

开发者ID:kcly3027，项目名称:freePhoto，代码行数:12，代码来源:UserDAL.cs

示例10: data

        public void data()
        {
            p1 = new SQLiteParameter("@person_id", DbType.Int32);
            p2 = new SQLiteParameter("@day", DbType.Int32);
            p3 = new SQLiteParameter("@month_id", DbType.Int32);
            p4 = new SQLiteParameter("@usage", DbType.Int32);
               // SQLiteParameter p4 = new SQLiteParameter("@w_usage", DbType.Int32);

            DataDao.sqlite_cmd.Parameters.Add(p1);
            DataDao.sqlite_cmd.Parameters.Add(p2);
            DataDao.sqlite_cmd.Parameters.Add(p3);
            DataDao.sqlite_cmd.Parameters.Add(p4);

            //for (person_id = 1; person_id <= 10000; person_id++)
            for (person_id = 1; person_id <= 10; person_id++)
            {
               // for (month_id = 1; month_id <= 24; month_id++)
                 for (month_id = 1; month_id <= 12; month_id++)
                {
                    for (day = 1; day <= 30; day++)
                    // for (day = 1; day <= 10; day++)
                    {
                        int usage = rnd.Next(1, 12);
                        p1.Value = person_id;
                        p2.Value = day;
                        p3.Value = month_id;
                        p4.Value = usage;
                        DataDao.sqlite_cmd.ExecuteNonQuery();

                    }
                }

            }
        }

开发者ID:vivekmurli，项目名称:customerinfo，代码行数:34，代码来源:InsertQuery.cs

示例11: insertCity

        public void insertCity()
        {
            try
            {
                //DataDao.sqlite_cmd = sqlite_conn.CreateCommand();
                DataDao.sqlite_cmd.CommandText = "insert into city(city_id,city_name,state) values (@city_id,@city_name,@state)";
                p1 = new SQLiteParameter("@city_id", DbType.Int32);
                p2 = new SQLiteParameter("@city_name", DbType.String);
                p3 = new SQLiteParameter("@state", DbType.String);

                DataDao.sqlite_cmd.Parameters.Add(p1);
                DataDao.sqlite_cmd.Parameters.Add(p2);
                DataDao.sqlite_cmd.Parameters.Add(p3);

                for (int m = 1; m <= 3; m++)
                {
                   // for (int n = m; n <= m-1; n++)
                   // {
                       p1.Value = m;
                       p2.Value = city_name[m-1];
                       p3.Value = state[0];
                       DataDao.sqlite_cmd.ExecuteNonQuery();
                   // }

                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("SQLite Exception : {0}", ex.Message);

            }
        }

开发者ID:vivekmurli，项目名称:customerinfo，代码行数:32，代码来源:InsertQuery.cs

示例12: SelectArray

        public static List<Object[]> SelectArray( IDbTransaction transaction, string statement, IEnumerable<object> parameters )
        {
            List<Object[]> rows = null;
            using ( IDbCommand Command = new SQLiteCommand() ) {
                Command.Connection = transaction.Connection;
                Command.CommandText = statement;
                foreach ( object p in parameters ) {
                    SQLiteParameter sqp = new SQLiteParameter();
                    sqp.Value = p;
                    Command.Parameters.Add( sqp );
                }

                IDataReader rd = Command.ExecuteReader();

                rows = new List<object[]>();
                if ( rd.Read() ) {
                    Object[] fields = new Object[rd.FieldCount];
                    do {
                        for ( int i = 0; i < rd.FieldCount; ++i ) {
                            try {
                                fields[i] = rd.GetValue( i );
                            } catch ( OverflowException ) {
                                // workaround, GetValue() and GetValues() try to incorrectly cast a signed tinyint to an unsigned byte
                                fields[i] = rd.GetInt32( i );
                            }
                        }
                        rows.Add( fields );
                        fields = new Object[rd.FieldCount];
                    } while ( rd.Read() );
                }
            }
            return rows;
        }

开发者ID:AdmiralCurtiss，项目名称:HyoutaTools，代码行数:33，代码来源:SqliteUtil.cs

示例13: ExecuteNonQuery

        public static int ExecuteNonQuery(string sql, SQLiteParameter[] parameters = null, string connectionString = "")
        {
            if (string.IsNullOrEmpty(connectionString))
                connectionString = ConnectionString;

            int affectedRows;
            using (var connection = new SQLiteConnection(connectionString))
            {
                connection.Open();
                using (var transaction = connection.BeginTransaction())
                {
                    using (var command = new SQLiteCommand(connection))
                    {
                        command.CommandText = sql;
                        if (parameters != null)
                        {
                            command.Parameters.AddRange(parameters);
                        }
                        affectedRows = command.ExecuteNonQuery();
                    }
                    transaction.Commit();
                }
            }
            return affectedRows;
        }

开发者ID:atwayne，项目名称:guesswhat_wordservice，代码行数:25，代码来源:SQLiteHelper.cs

示例14: RemoveConnections

		public void RemoveConnections(Int64 parentQueryId)
		{
			const string parentQueryIdParamName = "@parentQueryId";
			string       strSQLClause           = null;

			if (!this.ReadOnly)
			{
				using (this.Connection.OpenWrapper())
				{
					var deleteCommand = new RowDeleteCommand(this.Connection, this.TableDefinition);

					strSQLClause = string.Format(
						"[{0}] = {1}",
						ParentQueryIdFn,
						parentQueryIdParamName
					);

					var parentQueryIdParam = new SQLiteParameter(parentQueryIdParamName, DbType.Int64)
					{
						Value = parentQueryId
					};

					var parameters = new List<SQLiteParameter> { parentQueryIdParam };

					deleteCommand.SetCommandConstraints(strSQLClause, parameters);

					deleteCommand.Execute(100);
				}
			}
		}

开发者ID:saycale，项目名称:MSSQLServerAuditor，代码行数:30，代码来源:DynamicConnectionDirectory.cs

示例15: GetRecord

 public static int GetRecord(string name)
 {
     string sql = "select rank from Demo where [email protected]";
     SQLiteDBHelper db = new SQLiteDBHelper(dbPath);
     SQLiteParameter[] parameters = new SQLiteParameter[] { new SQLiteParameter("@name", SqliteEscape(name)) };
     return int.Parse(db.ExecuteScalar(sql, parameters).ToString());
 }

开发者ID:yuyuzeze，项目名称:Site，代码行数:7，代码来源:DBUitility.cs

示例16: SearchForBook

        private static void SearchForBook(string input)
        {
            db.Open();
            using (db)
            {

                string sqlStr = "SELECT AuthorName, titleBook, publishDate, ISBN FROM books " +
                    "JOIN authors " +
                    "ON authors.Books_idBooks = books.idBooks " +
                    "WHERE titleBook LIKE @input";
                SQLiteParameter cmdParam = new SQLiteParameter("@input", "%" + input + "%");
                SQLiteCommand cmd = new SQLiteCommand(sqlStr, db.ConnectionHandle);
                cmd.Parameters.Add(cmdParam);
                SQLiteDataReader reader = cmd.ExecuteReader();
                using (reader)
                {
                    while (reader.Read())
                    {
                        string author = (string)reader["AuthorName"];
                        string title = (string)reader["titleBook"];
                        DateTime date = (DateTime)reader["publishDate"];
                        long isbn = (long)reader["ISBN"];
                        Console.WriteLine("{0}: {1} {2} {3}", author, title, date, isbn);
                    }
                }
            }
        }

开发者ID:Gerya，项目名称:TelerikAcademy，代码行数:27，代码来源:Program.cs

示例17: SetValue

 public void SetValue(string key, string value)
 {
     string ExistRecordSql = "SELECT count(1) FROM profiles WHERE Key = '{0}'";
     int record = Convert.ToInt32(dbHelper.ExecuteScalar(string.Format(ExistRecordSql, key), null));
     if (record > 0)
     {
         string UpdSql = @"UPDATE  profiles SET Value [email protected] where Key = @Key ";
         SQLiteParameter[] parameter = new SQLiteParameter[]
         {
             new SQLiteParameter("@Key", key),
             new SQLiteParameter("@Value",value)
         };
         dbHelper.ExecuteNonQuery(UpdSql, parameter);
     }
     else
     {
         string InsSql = @"INSERT INTO profiles(Key, Value) values(@Key,@Value)";
         SQLiteParameter[] parameter = new SQLiteParameter[]
         {
                 new SQLiteParameter("@Key", key),
             new SQLiteParameter("@Value",value)
         };
         dbHelper.ExecuteNonQuery(InsSql, parameter);
     }
 }

开发者ID:rew170，项目名称:soomecode，代码行数:25，代码来源:ProfileDAO.cs

示例18: CreateParameter

 public override DbParameter CreateParameter(string name, Type type)
 {
     DbParameter p = new SQLiteParameter();
     p.DbType = GetDbType(type);
     p.ParameterName = name;
     return p;
 }

开发者ID:WildGenie，项目名称:softlynx-activesql，代码行数:7，代码来源:Specifics.cs

示例19: AddFile

 public bool AddFile(string fileName, string description, string mapName, string featureSource, long uid)
 {
     bool result = false;
     SQLiteTransaction trans = this._conn.BeginTransaction();
     try
     {
     using (SQLiteCommand cmd = this._conn.CreateCommand())
     {
         cmd.CommandText = "INSERT INTO tblFiles(FeatureSourceId, FeatureId, MapName, FileName, Description) VALUES(@FeatureSourceId, @FeatureId, @MapName, @FileName, @Description)";
         SQLiteParameter featSourceIdParam = new SQLiteParameter("@FeatureSourceId", this.GetFeatureSourceId(featureSource, true));
         SQLiteParameter featIdParam = new SQLiteParameter("@FeatureId", uid);
         SQLiteParameter mapNameParam = new SQLiteParameter("@MapName", mapName);
         SQLiteParameter fileNameParam = new SQLiteParameter("@FileName", fileName);
         SQLiteParameter descriptionParam = new SQLiteParameter("@Description", description);
         cmd.Parameters.AddRange(new SQLiteParameter[] { featSourceIdParam, featIdParam, mapNameParam, fileNameParam, descriptionParam });
         cmd.ExecuteNonQuery();
     }
     trans.Commit();
     result = true;
     }
     catch (SQLiteException)
     {
     trans.Rollback();
     }
     finally
     {
     if (trans != null)
     {
         trans.Dispose();
     }
     }
     return result;
 }

开发者ID:ranyaof，项目名称:Meuhedet，代码行数:33，代码来源:DBUploadFiles.cs

示例20: ExcuteInsertReturnRowID

 /// <summary>
 /// 对SQLite数据库执行Insert操作，并返回rowID。
 /// </summary>
 /// <param name="sql">要执行的Insert SQL语句</param>
 /// <param name="parameters">执行Insert语句所需要的参数，参数必须以它们在SQL语句中的顺序为准</param>
 /// <returns>RowID</returns>
 public static int ExcuteInsertReturnRowID(string sql, SQLiteParameter[] parameters = null)
 {
     int rowID = -1;
     int affectedRows;
     using (SQLiteConnection connection = new SQLiteConnection(connectionString))
     {
         connection.Open();
         using (DbTransaction transaction = connection.BeginTransaction())
         {
             using (SQLiteCommand command = new SQLiteCommand(connection))
             {
                 command.CommandText = sql;
                 if (parameters != null)
                 {
                     command.Parameters.AddRange(parameters);
                 }
                 affectedRows = command.ExecuteNonQuery();
             }
             transaction.Commit();
         }
         if (affectedRows == 0)
         {
             return rowID;
         }
         string getRowIDSql = "select last_insert_rowid()";
         using (SQLiteCommand getRowIDCmd = new SQLiteCommand(getRowIDSql, connection))
         {
             SQLiteDataAdapter adapter = new SQLiteDataAdapter(getRowIDCmd);
             DataTable data = new DataTable();
             adapter.Fill(data);
             rowID = Convert.ToInt32(data.Rows[0][0]);
         }
     }
     return rowID;
 }

开发者ID:a707937337，项目名称:SalesManager，代码行数:41，代码来源:SQLiteDBHelper.cs

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

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# SQLite.SQLiteStatement类代码示例发布时间：2022-05-26

C# SQLite.SQLiteDataReader类代码示例发布时间：2022-05-26

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18142|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9632|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8161|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8538|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8439|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9359|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8409|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7847|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8395|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7387|2022-11-06

客服电话

电子邮件

C# SQLite.SQLiteParameter类代码示例

示例1: AddRili

示例2: ExecuteNonQuery

示例3: GetUsers

示例4: Main

示例5: Login

示例6: AddPatientBaseInfo

示例7: ExecuteDataTable

示例8: addUser

示例9: AddLoginHistory

示例10: data

示例11: insertCity

示例12: SelectArray

示例13: ExecuteNonQuery

示例14: RemoveConnections

示例15: GetRecord

示例16: SearchForBook

示例17: SetValue

示例18: CreateParameter

示例19: AddFile

示例20: ExcuteInsertReturnRowID

请发表评论

全部评论

上一篇：

下一篇：

DelphiXE7用indy开发微信公众平台（3）-验

bradtraversy/iweather: Ionic 3 mobile we

CVE-2020-25588

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053