Loading

How Do I: Get the column name from a datareader?

Gustavo

Hello:
I am trying to get the name of the column in the datareader in a for/loop. I can get the value of the column, but I also need the name. What do I have wrong or how can I get it?

for (int i = 0; i < ClassDB.DBDataReader.FieldCount - 1; i++)
{
//TheColumnName = ClassDB.DBDataReader....????
TheColumnValue = ClassDB.DBDataReader[i].ToString();
MessageBox.Show("i=" + i + " TheColumnName=" + TheColumnName + " TheColumnValue=" + TheColumnValue);
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Gustavo16y ago
I love c# Corner. Some times when I get the reply email, it gives me some links to look at. Some times the links are very good. This time it gave me the link I was looking for. So I answered my own question with the help of c# Corner auto reply.

This is the line I needed.
TheColumnName = ClassDB.DBDataReader.GetName(i);

BTW: Can someone tell me how I can flag my post as answered?