How can I pivot results from the DataGridView into my update function?

I have a DataGridView control with 2 columns that is like a pivot table because it presents a row of data from my SQL Server 2005 database in rows instead of columns:

column1name value
column2name value
...
columnNname value

I want to update the values back to the database. There are 29 values in the update function I created for the row. Do I have to iterate through each row, turning each value in the 2nd column into a typed-variable and then insert these into the function ...or is there an easier way

Ideally, I'd like to throw these values into an array or something and then pass the array to the function; something like that would save me a lot of time.