private void btnUpdate_Click(object sender, EventArgs e) { IObjectContainer db = Db4oEmbedded.OpenFile("pilotdb.db"); //Query By Example var pilotTemp = new Pilot(); pilotTemp.Name = txtName.Text;//dua vao Name (key) IObjectSet result = db.QueryByExample(pilotTemp); var pilot = (Pilot)result[0]; pilot.Point += Convert.ToInt32(txtPoint.Text); db.Store(pilot); db.Close(); }
private void btnLoad_Click(object sender, EventArgs e) { IObjectContainer db = Db4oEmbedded.OpenFile("pilotdb.db"); //Query By Example var pilotTemp = new Pilot(); if (!string.IsNullOrEmpty(txtName.Text)) { pilotTemp.Name = txtName.Text; } List <Pilot> data = new List <Pilot>(); IObjectSet result = db.QueryByExample(pilotTemp); for (int i = 0; i < result.Count; i++) { var plObj = (Pilot)result[i]; data.Add(plObj); } db.Close(); dataGridView1.DataSource = null; dataGridView1.DataSource = data; }