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