How do I update two columns in a database using datasets and datatables
<p>I want to update two columns in my database table. </p>

<p>Below is the code that I use to iterate through a datagrid to get addresses of shops.
In my database which I use to search for GPS coordinates using the method GetGoogleSearch.</p>

<p>I then get the GPS coordiates from the internet and I put them in a datatable.</p>

<p>I now want to update the columns and put that data I found and update columns as they are currently set to NULL for the coordinates Longitude and Latitude in the database. </p>

<p>Code is below for iterating and getting GPS coordinates is below. </p>

<p>Collapse | Copy Code</p>

<pre><code>private void btnMapStoreAddresses_Click(object sender, EventArgs e)
{

    AddressServiceData _AddressServiceData = new AddressServiceData();

    try
    {

        DataTable _PnPStoresListDataTable = new DataTable();
        string address = string.Empty;

        int GridRowCounnt = 0;
        GridRowCounnt = dgrgPnPStores.RowCount;


        for (int i = 0; i &lt; GridRowCounnt; i++)
        {
             address = dgrgPnPStores.Rows[i].Cells[5].Value.ToString();
            _PnPStoresListDataTable = _AddressServiceData.GetGoogleSearch("", address + " South Africa", "", "");             


        }

}
</code></pre>
