public void RefreshData()
{
// Receiving field instantiated by descriptor.
var table = tableDescriptor.GetField <IList>("table");
// Clearing current data.
table.Clear();
// Executing select query.
string sql = " SELECT * FROM `item` ";
using (MySqlCommand cmd = new MySqlCommand(sql, connection))
{
connection.Open();
MySqlDataReader reader = cmd.ExecuteReader();
/// Adding data to the table.
while (reader.Read())
{
// Genarating source.
var item = new TableRowDescriptor()
{
id = reader.GetInt32("id"),
title = reader.GetString("title"),
description = reader.GetString("description"),
price = reader.GetFloat("price"),
};
// Adding to the table. (affect UI and binded member)
table.Add(item);
}
}
}
public void UpdateItem(TableRowDescriptor row)
{
ExecuteScalarSql(string.Format(
"UPDATE `item` SET `title`={0}, `description`={1}, `price`={2} WHERE `id`={3};",
row.title, row.description, row.price, row.id));
}
