// データを更新するする
public void UpdateData(TAHLocalDBDataEntry entry)
{
using (SQLiteCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = "UPDATE Data SET DATA=@data WHERE DATAID=@id";
cmd.Parameters.AddWithValue("id", entry.dataid.ToString());
cmd.Parameters.AddWithValue("data", entry.data);
cmd.ExecuteNonQuery();
}
}
// cmd.CommandText = "CREATE TABLE Data (DATAID PRIMARY KEY, DATA BLOB)";
// データを取得する
public TAHLocalDBDataEntry GetData(int id)
{
TAHLocalDBDataEntry entry = null;
using (SQLiteCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = "SELECT DATAID,DATA FROM Data WHERE DATAID=@id";
cmd.Parameters.AddWithValue("id", id.ToString());
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
entry = new TAHLocalDBDataEntry();
entry.dataid = int.Parse(reader[0].ToString());
entry.data = (byte[])reader[1];
break;
}
}
}
return(entry);
}
public int AddData(TAHLocalDBDataEntry entry)
{
int id = -1;
using (SQLiteCommand cmd = cnn.CreateCommand())
{
// acpathを追加する.
cmd.CommandText = "INSERT INTO Data (DATA) VALUES(@data)";
cmd.Parameters.AddWithValue("data", entry.data);
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT last_insert_rowid()";
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
id = Int16.Parse(reader[0].ToString());
break;
}
}
}
return(id);
}