Getting a column from from a datatable

[macupryk]

I am not sure how to get a column from a datatable, I cannot use foreach.
DataColumn dataColumn = DataColumn TEXTDT.Columns[2+columns].ColumnName.Tri m();



if (rows < TEXTDT.Rows.Cou nt) // this will prevent rows to exceed number of rows in TEXTDT
{
// Insert each answer
DataColumn dataColumn = DataColumn TEXTDT.Columns[2+columns].ColumnName.Tri m();

string answer;


if ((dataColumn.Co lumnName != "QUEST") && (dataColumn.Col umnName != "S_DAT"))
{
// One column
if ((TEXTDT.Rows[rows][dataColumn.Colu mnName] != DBNull.Value) && (dataColumn.Col umnName == var.name.Trim() ))
{
answer = TEXTDT.Rows[rows][dataColumn.Colu mnName].ToString();
projectQuestion ToDatabase.Proj ectResponseandR espondentToDB(T EXTDT.Rows[rows], answer, intId, Convert.ToInt32 (rows));
}
}

if (columns + 2 == TEXTDT.Columns. Count)
columns = 0;
}
if (rows < TEXTDT.Rows.Cou nt) // this will prevent rows to exceed number of rows in TEXTDT
{
// Insert each answer
DataColumn dataColumn = TEXTDT.Columns[2+columns];
string answer;



if ((dataColumn.Co lumnName.Trim() != "QUEST") && (dataColumn.Col umnName.Trim() != "S_DAT"))
{
// One column
if ((TEXTDT.Rows[rows][dataColumn.Colu mnName.Trim()] != DBNull.Value) && (dataColumn.Col umnName.Trim() == var.name.Trim() ))
{
answer = TEXTDT.Rows[rows][dataColumn.Colu mnName.Trim()].ToString();
projectQuestion ToDatabase.Proj ectResponseandR espondentToDB(T EXTDT.Rows[rows], answer, intId, Convert.ToInt32 (rows));
}
}

if (columns + 2 == TEXTDT.Columns. Count)
columns = 0;
}
rows++;
columns++;
It is crashing on this line
if ((TEXTDT.Rows[rows][dataColumn.Colu mnName.Trim()] != DBNull.Value) && (dataColumn.Col umnName.Trim() == var.name.Trim() ))

[anaphaxeon]

why can't you use foreach?

foreach(DataColumn dc in DataTable.Columns)
{
   if(dc.ColumnName == "What you're looking for")
   {
     //do something
    }
}