Can someone help me figuere out how to get the returned data frm the code
beow. How do I get each column of data returned into a variable. I basically
get the selcted value in a datagrid view, then I want to run a query on that
to get another column in that record.

commandCol = scriptDataGridView[4, rowNum].FormattedValue.ToString();

string sCommand = "SELECT CommandString FROM Commands WHERE CommandName = "
+ commandCol;                     

this.commandsTableAdapter.FillByCommandName(this.fixed1DataSet.Commands,
sCommand);

Now how do I access each returned value?

Datagrid does not update datasource efficiently
Using a Variable within a Connection String
Subquery in SqlDataSource failing
updating database views via tableadapter?
DbDataReadet.GetOrdinal() - duplicate column name