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 問い合わせ
