Adding new field to a database table in run time

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
Adding new field to a database table in run time

ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics 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

Old

October 6th, 2005, 10:07 AM

dotnet cat dotnet cat is offline

dotnet cat is offline

Registered User

Join Date: Aug 2005

Posts: 5

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Adding new field to a database table in run time

Hi everyone,
can anyone help me to do this? I wanna add a new field to existing table in a database using vb.net. How can I achieve this?
Thanks in advance.

Old

October 6th, 2005, 01:36 PM

jbenson001 jbenson001 is offline

jbenson001 is offline

Friend of Wrox

Join Date: Nov 2003

Posts: 1,348

Thanks: 0

Thanked 5 Times in 5 Posts

Default

You would need to construct an AlterTable statement(See SQL Server's Books On Line)
Then use the Execute NonQueryMethod

Jim

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding User Forms at Run time	RichRansom	BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2	0	May 30th, 2008 11:49 AM
Adding button at run time	msathyaprasad90	ASP.NET 1.0 and 1.1 Professional	8	August 9th, 2006 11:05 PM
Adding Text boxes on run time	jmss66	VB How-To	1	March 31st, 2006 03:32 PM
Adding controls at run-time !!	kishore_peddi	C#	0	October 13th, 2003 06:52 AM