views:

285

answers:

0

Hi all,

I'm using SqlDataReader.GetSchemaTable method and I realized that return ColumName into Upper Case mode.

There is any way to avoid this?

The code I'm using is:

System.Data.DataTable dt = reader.GetSchemaTable();

and I found into

dt.Rows[i]["ColumnName"].ToString()

the name of Column into Upper Case; for example if I have on table database with a column named 'Login', it returns 'LOGIN'.

It's possible to retrieve the column name like defined into database?

I hope you can help me!