...
DataSet.CommadText="select * from my_table";
DataSet.ExecuteQuery();
...
//-----------------------------------------------------------------//
DataSet.FieldValues["my_field"]="my new value";
DataSet.Update();
//-----------------------------------------------------------------//
// is equivalent with
var current_id= DataSet.FieldValues["id"].ToNumber();
DataSet.CommandText="update my_table set my_field=\"my new value\" where id=$current_id";
//-----------------------------------------------------------------//
|