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.Trim();



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

string answer;


if ((dataColumn.ColumnName != "QUEST") && (dataColumn.ColumnName != "S_DAT"))
{
// One column
if ((TEXTDT.Rows[rows][dataColumn.ColumnName] != DBNull.Value) && (dataColumn.ColumnName == var.name.Trim()))
{
answer = TEXTDT.Rows[rows][dataColumn.ColumnName].ToString();
projectQuestionToDatabase.ProjectResponseandRespon dentToDB(TEXTDT.Rows[rows], answer, intId, Convert.ToInt32(rows));
}
}

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



if ((dataColumn.ColumnName.Trim() != "QUEST") && (dataColumn.ColumnName.Trim() != "S_DAT"))
{
// One column
if ((TEXTDT.Rows[rows][dataColumn.ColumnName.Trim()] != DBNull.Value) && (dataColumn.ColumnName.Trim() == var.name.Trim()))
{
answer = TEXTDT.Rows[rows][dataColumn.ColumnName.Trim()].ToString();
projectQuestionToDatabase.ProjectResponseandRespon dentToDB(TEXTDT.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.ColumnName.Trim()] != DBNull.Value) && (dataColumn.ColumnName.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
    }
}