Hi dudes.

I want to write an ASP.NET application with C# language that let user to manage fields of a table in a sql server 2000 database, such as adding or removing a field or changing type of fields and so on.

The question is, how can i obtain all fields of a certain table in a sql server 2000 database? Not only name of fields but other properties of the fields like nullablity, type, length and so on. How can i obtain them?


Can anyone help me?

Thanx alot.

Hii MTLedari!!
This is the best link for you.
http://aspalliance.com/articleviewer...aid=349&pid=-1
Hope this will help you

Cheers :)

vinod

Thank you very much.
This helped me.

But I want this thread remains open. I guess i will have more questions during i do the project.