public int Update(Obj_DanhHieu obj) { SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection); cm.CommandType = CommandType.Text; cm.CommandText = "UPDATE " + LocalTable.TableName + " SET " + "nam = @nam, " + "danhHieu = @danhHieu, " + "trangThai = @trangThai " + "WHERE id = @id"; cm.Parameters.Add(new SQLiteParameter("@nam", obj.Nam)); cm.Parameters.Add(new SQLiteParameter("@danhHieu", obj.DanhHieu)); cm.Parameters.Add(new SQLiteParameter("@trangThai", obj.TrangThai)); cm.Parameters.Add(new SQLiteParameter("@id", obj.ID)); DbAccess.OpenConnection(); int i = cm.ExecuteNonQuery(); DbAccess.CloseConnection(); if (i == 1) { foreach (DataRow item in LocalTable.Rows) { if ((long)item["id"] == obj.ID) { item["nam"] = obj.Nam; item["danhHieu"] = obj.DanhHieu; item["trangThai"] = obj.TrangThai; break; } } } return(i); }