1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| DBConnector.Connect(DataProvider.MySql, "data source=localhost;user id=root;database=test");
IDbCommand SelectCommand=DBConnector.CreateCommand("SELECT * FROM test");
IDbCommand InsertCommand=DBConnector.CreateCommand("INSERT INTO test (duration) VALUES (?)",
new DBParameter(null,DataType.VarChar,20,"duration"));
IDbCommand UpdateCommand=DBConnector.CreateCommand("UPDATE test SET duration = ? WHERE id = ?",
new DBParameter(null,DataType.VarChar,20,"duration"),
new DBParameter(null,DataType.Long,20,"id"));
IDbCommand DeleteCommand=DBConnector.CreateCommand("DELETE FROM test WHERE id = ?",
new DBParameter(null,DataType.Long,20,"id"));
IDbDataAdapter adapter = DBConnector.GetAdapter(
SelectCommand,InsertCommand,UpdateCommand,DeleteCommand);
DataSet ds = new DataSet();
adapter.Fill(ds); // Pas d'implémentation de adapter.Fill(DataSet,string)
// TODO modification du DataSet
ds.Tables [0].Rows [3] ["duration"] = "coucou !"; // Pas pratique.
// Encore de modifications...
// Et un peu plus loin la mise à jour ou l'annulation des modifs...
adapter.Update(ds);
ds.AcceptChanges(); |
Partager