public string GetData(int peck_id, string user)
    {
        string json = string.Empty;
        var sqlConnectionSb = new SQLiteConnectionStringBuilder { DataSource = @"pigeonpeck.db" };
        using (var cn = new SQLiteConnection(sqlConnectionSb.ToString()))
        {
            cn.Open();
            using (var cmd = new SQLiteCommand(cn))
            {
                //テーブル作成
                cmd.CommandText = "SELECT * FROM peck WHERE id > "+ peck_id;
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        json += (string)reader["peck"];
                    }
                }
            }
        }
        return json;
    }
      C# Sqlite 問い合わせ
  
  
  
  未分類
