I have an issue whereby I find the column name from INFORMATION\_SCHEMA.columns

```
daISC = new SqlDataAdapter(
    string.Format(
        "SELECT column_name FROM INFORMATION_SCHEMA.columns WHERE table_name = 'DynamicDataSubjects' AND ordinal_position = 20"
    ), cn);

```

I then want to use that `colum_name` to find the value of the data within

```
string sColumnName = row2["column_name"].ToString();

daDDS = new SqlDataAdapter(
    string.Format(
        "SELECT '{0}' FROM DynamicDataSubjects WHERE pupil_id = {1} AND interim_id = {2}",
        sColumnName, iPupilID, iInterimID
    ), cn);

```

Unfortunately this throws an error as the `sColumnName` is treated as being text and returns itself. Without the `'{0}'` throws an exception.

Hopefully someone can understand what I'm trying to say and point me in the right direction.