Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to determine the type of a SQL column?
Message
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00712325
Message ID:
00712359
Vues:
8
This message has been marked as the solution to the initial question of the thread.
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
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform