示例#1
0
        public static void InsertData(Data data)
        {
            string sql = "INSERT INTO Demo(Name,Rank,Comments)values(@Name,@Rank,@Comments)";
            SQLiteDBHelper db = new SQLiteDBHelper(dbPath);

            SQLiteParameter[] parameters = new SQLiteParameter[]{
                                                 new SQLiteParameter("@Name",SqliteEscape(data.Name)),
                                         new SQLiteParameter("@Rank",data.Rank),
                                         new SQLiteParameter("@Comments",SqliteEscape(data.Comments))
                                         };
            db.ExecuteNonQuery(sql, parameters);
        }
示例#2
0
 private IEnumerable<Data.Filter> GetAllFilter(Data.QUERYEntities context, int headerID)
 {
     return context.Filters.Where(f => f.HeaderID == headerID);
 }