Cathi,

I knew it would be something simple.

Thank You,
Doug
>How about using the ToString method like the following:
>
>

>Att[i,2] = Attributes.Rows[i]["DataType"].ToString();
>

>
>>All,
>>
>>I've been using GetSchemaTable() to retrieve the attributes for columns in a SQL table.
>>
>>I was wondering how to determine the specific datatype of the column.
>>

>>DataTable Attributes = DR.GetSchemaTable();
>>
>>for(int i;i < Attributes.Rows.Count; i++)
>>{
>>   Att[i,0] = Attributes.Rows[i]["ColumnName"];
>>   Att[i,1] = Attributes.Rows[i]["AllowDBNull"];
>>   Att[i,2] = Attributes.Rows[i]["DataType"];
>>}
>>

>>
>>If I examine Attributes.Rows[i]["DataType"] in the watch window I see {System.RuntimeType}. Below it I see the plus sign in the square with
>>System.Type {"System.String"}
>>
>>How can I readily determine that Attributes.Rows[i]["DataType"] = "String" ?
>>
>>I tried Reflection with Type t = Attributes.Rows[i]["DataType"].GetType(); But that did not further the crusade either.
>>
>>This is probably simple, but I do not see the tree in the forest.
>>TIA,
>>Doug