Como salvar dados de um objeto em um banco de dados

Artigo
06/10/2015

You can save data in objects to a database by passing the values from your object to one of the TableAdapter's DBDirect methods (for example, TableAdapter.Insert). Para obter mais informações, consulte Visão geral de TableAdapter.

To save data from a collection of objects, loop through the collection of objects (for example, a for-next loop) and send the values for each object to the database using one of the TableAdapter's DBDirect methods.

By default, DBDirect methods are created on a TableAdapter that can be executed directly against the database. These methods can be called directly and do not require DataSet or DataTable objects to reconcile changes in order to send updates to a database.

Dica

When you are configuring a TableAdapter, the main query must provide enough information in order for the DBDirect methods to be created.For example, if a TableAdapter is configured to query data from a table that does not have a primary key column defined, it does not generate DBDirect methods.

Método DBDirect do TableAdapter	Descrição
TableAdapter.Insert	Adds new records into a database allowing you to pass in individual column values as method parameters.
TableAdapter.Update	Atualizações de registros existentes em um banco de dados. The Update method takes original and new column values as method parameters. Os valores originais são usados para localizar o registro original, e os novos valores são usados para atualizar esse registro. The TableAdapter.Update method is also used to reconcile changes in a dataset back to the database by taking a DataSet, DataTable, DataRow, or array of DataRows as method parameters.
TableAdapter.Delete	Exclui registros existentes do banco de dados com base nos valores originais da coluna que foram passados como parâmetros do método.

TableAdapter.Insert

Adds new records into a database allowing you to pass in individual column values as method parameters.

TableAdapter.Update

Atualizações de registros existentes em um banco de dados. The Update method takes original and new column values as method parameters. Os valores originais são usados para localizar o registro original, e os novos valores são usados para atualizar esse registro.

The TableAdapter.Update method is also used to reconcile changes in a dataset back to the database by taking a DataSet, DataTable, DataRow, or array of DataRows as method parameters.

TableAdapter.Delete

Exclui registros existentes do banco de dados com base nos valores originais da coluna que foram passados como parâmetros do método.

To save new records from an object to a database

Create the records by passing the values to the TableAdapter.Insert method.

The following example creates a new customer record in the Customers table by passing the values in the currentCustomer object to the TableAdapter.Insert method.

Private Sub AddNewCustomer(ByVal currentCustomer As Customer)

    CustomersTableAdapter.Insert(
        currentCustomer.CustomerID,
        currentCustomer.CompanyName,
        currentCustomer.ContactName,
        currentCustomer.ContactTitle,
        currentCustomer.Address,
        currentCustomer.City,
        currentCustomer.Region,
        currentCustomer.PostalCode,
        currentCustomer.Country,
        currentCustomer.Phone,
        currentCustomer.Fax)
End Sub

private void AddNewCustomers(Customer currentCustomer)
{
    customersTableAdapter.Insert( 
        currentCustomer.CustomerID, 
        currentCustomer.CompanyName, 
        currentCustomer.ContactName, 
        currentCustomer.ContactTitle, 
        currentCustomer.Address, 
        currentCustomer.City, 
        currentCustomer.Region, 
        currentCustomer.PostalCode, 
        currentCustomer.Country, 
        currentCustomer.Phone, 
        currentCustomer.Fax);
}

To update existing records from an object to a database

Modify the records by calling the TableAdapter.Update method and passing in the new values to update the record and passing in the original values to locate the record.

Dica

Your object needs to maintain the original values in order to pass them to the Update method.This example uses properties with an orig prefix to store the original values.

The following example updates an existing record in the Customers table by passing the new and original values in the Customer object to the TableAdapter.Update method.

Private Sub UpdateCustomer(ByVal cust As Customer)

        CustomersTableAdapter.Update(
        cust.CustomerID,
        cust.CompanyName,
        cust.ContactName,
        cust.ContactTitle,
        cust.Address,
        cust.City,
        cust.Region,
        cust.PostalCode,
        cust.Country,
        cust.Phone,
        cust.Fax,
        cust.origCustomerID,
        cust.origCompanyName,
        cust.origContactName,
        cust.origContactTitle,
        cust.origAddress,
        cust.origCity,
        cust.origRegion,
        cust.origPostalCode,
        cust.origCountry,
        cust.origPhone,
        cust.origFax)
End Sub

private void UpdateCustomer(Customer cust)
{
    customersTableAdapter.Update(
        cust.CustomerID,
        cust.CompanyName,
        cust.ContactName,
        cust.ContactTitle,
        cust.Address,
        cust.City,
        cust.Region,
        cust.PostalCode,
        cust.Country,
        cust.Phone,
        cust.Fax,
        cust.origCustomerID,
        cust.origCompanyName,
        cust.origContactName,
        cust.origContactTitle,
        cust.origAddress,
        cust.origCity,
        cust.origRegion,
        cust.origPostalCode,
        cust.origCountry,
        cust.origPhone,
        cust.origFax);
}

To delete existing records from a database

Delete the records by calling the TableAdapter.Delete method and passing in the original values to locate the record.

Dica

Your object needs to maintain the original values in order to pass them to the Delete method.This example uses properties with an orig prefix to store the original values.

The following example deletes a record from the Customers table by passing the original values in the Customer object to the TableAdapter.Delete method.

Private Sub DeleteCustomer(ByVal cust As Customer)

    CustomersTableAdapter.Delete(
        cust.origCustomerID,
        cust.origCompanyName,
        cust.origContactName,
        cust.origContactTitle,
        cust.origAddress,
        cust.origCity,
        cust.origRegion,
        cust.origPostalCode,
        cust.origCountry,
        cust.origPhone,
        cust.origFax)
End Sub

private void DeleteCustomer(Customer cust)
{
    customersTableAdapter.Delete(
        cust.origCustomerID,
        cust.origCompanyName,
        cust.origContactName,
        cust.origContactTitle,
        cust.origAddress,
        cust.origCity,
        cust.origRegion,
        cust.origPostalCode,
        cust.origCountry,
        cust.origPhone,
        cust.origFax);
}

Segurança

You must have permission to perform the selected INSERT, UPDATE, or DELETE on the table in the database.

Consulte também

Compartilhar via

Como salvar dados de um objeto em um banco de dados

To save new records from an object to a database

To update existing records from an object to a database

To delete existing records from a database

Segurança

Consulte também

Tarefas

Conceitos

Outros recursos

Recursos adicionais