Assign a specific DataRow to a variable using the generated FindBy method, and then use that variable to access the columns you want to edit and assign new values to them.

In the following example, the CustomerID column is the primary key of the Customers table, so the generated FindBy method is FindByCustomerID.

Dim customersRow As NorthwindDataSet.CustomersRow
customersRow = NorthwindDataSet1.Customers.FindByCustomerID("ALFKI")

customersRow.CompanyName = "Updated Company Name"
customersRow.City = "Seattle"

NorthwindDataSet.CustomersRow customersRow = 
    northwindDataSet1.Customers.FindByCustomerID("ALFKI");

customersRow.CompanyName = "Updated Company Name";
customersRow.City = "Seattle";;

Use the Select method of the DataTable to locate a specific row and assign new values to the desired columns

In the following example, the CustomerID column is the primary key of the Customers table, so calling the Select method and searching for the primary key will only result in finding one row. The return type is still an array of DataRows, so we access the (0) index, or first row, in the array.

Dim customerRow() As Data.DataRow
customerRow = DataSet1.Tables("Customers").Select("CustomerID = 'ALFKI'")

customerRow(0)("CompanyName") = "Updated Company Name"
customerRow(0)("City") = "Seattle"

DataRow[] customerRow = 
    dataSet1.Tables["Customers"].Select("CustomerID = 'ALFKI'");

customerRow[0]["CompanyName"] = "Updated Company Name";
customerRow[0]["City"] = "Seattle";

Assign a value to the specific column within a DataRow object.

Typed datasets utilize early binding, which exposes the table and column names as properties at design time. This results in code that is easier to both read and write.

The following example shows how to update the data in the CompanyName and City columns of the fifth record in the Customers table in the dataset:

NorthwindDataSet1.Customers(4).CompanyName = "Updated Company Name"
NorthwindDataSet1.Customers(4).City = "Seattle"

northwindDataSet1.Customers[4].CompanyName = "Updated Company Name";
northwindDataSet1.Customers[4].City = "Seattle";

Assign a value to a specific column within a DataRow object.

The table and column names of untyped datasets are not available at design time and must be accessed through their respective indices.

The following example shows how to update the data in the first two columns of the fifth record of the first table in Dataset1, accessing the data values with the tables, rows, and items (columns) collection indices:

DataSet1.Tables(0).Rows(4).Item(0) = "Updated Company Name"
DataSet1.Tables(0).Rows(4).Item(1) = "Seattle"

dataSet1.Tables[0].Rows[4].ItemArray[0] = "Updated Company Name";
dataSet1.Tables[0].Rows[4].ItemArray[1] = "Seattle";

The following example shows how to update the same data as the preceding example, replacing the collection indices with table, and column names passed as strings. You still need to know the index of the row you want to edit:

DataSet1.Tables("Customers").Rows(4).Item("CompanyName") = "Updated Company Name"
DataSet1.Tables("Customers").Rows(4).Item("City") = "Seattle"

dataSet1.Tables["Customers"].Rows[4]["CompanyName"] = "Updated Company Name";
dataSet1.Tables["Customers"].Rows[4]["City"] = "Seattle";