Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 27th, 2007, 06:28 AM
Authorized User
 
Join Date: Nov 2006
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to obtain fields of a certain table?

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.

  #2 (permalink)  
Old September 27th, 2007, 07:57 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: delhi, delhi, India.
Posts: 553
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to vinod_yadav1919 Send a message via Yahoo to vinod_yadav1919
Default

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

Cheers :)

vinod
  #3 (permalink)  
Old September 27th, 2007, 03:56 PM
Authorized User
 
Join Date: Nov 2006
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Overwriting fields in a table caterpillar SQL Server 2000 3 July 24th, 2006 09:00 AM
Fields in a dynamic table? Roshu Javascript How-To 12 January 10th, 2005 09:04 AM
Update Table fields karajian Access VBA 2 December 7th, 2004 03:48 PM
Updating table fields ppenn Access VBA 2 September 20th, 2003 06:09 PM
Listing the Fields in a table John Anthony Access VBA 1 July 4th, 2003 08:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.