Table

[simworld]

How to get the column name/Field name from a particular Table. I want to list them in dropdownlist in C#

[pmarfleet]

Ever heard of Google[^]?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Paul Conrad]

You need to provide more detail. What kind of database are you using?

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

[imsathy]

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'your table name'

Sathy

[simworld]

I am using SQL Server 2000.

[simworld]

Thank u very much

[imsathy]

Its a pleasure :)

Sathy

[Paul Conrad]

I think you can get table characteristics by looking in the system tables. Don't quite have the info right infront of me at the moment. ---modified Never mind, imsathy got it :-D

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon