I using sql server 2005

visual studio 2005

how can I get data type in my C# code


I have a data table name tbName with 3 column
Id -> bigint
Name -> nvarchar(200)
Des -> nvarchar(MAX)

how can I get "bigint" or "nvarchar (200)" .. in my C# code

i try with
string dbtype = datatable.Columns[0].DataType.ToString();//mean column ID
I just have "System.Int64", I want to have "bigint" as sql tyoe

thank you