how to create dynamic database using sql server and asp.net

[mhnazly]

Hi,
I am trying to build a web based system using asp.net and
sql server.
I would like to know on how to dynamically create a
webpage from a webpage, and at the same time dynamically
create the database in the back end.
For instance, there is a maintenance page in the client
side where user can add new webpages and automatically
created the database for the new type of data in the new
webpages.

[Ray at]

- Use a web-based html editor, such as
[url]http://www.richtextbox.com/richtextbox/[/url]
- Use CREATE DATABASE, as described in the BOL.
- For asp.net issues, specifically, see here. [url]http://www.aspfaq.com/5002[/url]

Ray at work

"mhnazly" <mhnazly@programmer.net> wrote in message
news:1d9b01c38814$f9d73560$3501280a@phx.gbl...

> Hi,
> I am trying to build a web based system using asp.net and
> sql server.
> I would like to know on how to dynamically create a
> webpage from a webpage, and at the same time dynamically
> create the database in the back end.
> For instance, there is a maintenance page in the client
> side where user can add new webpages and automatically
> created the database for the new type of data in the new
> webpages.

[Jeff Cochran]

On Wed, 1 Oct 2003 05:10:16 -0700, "mhnazly" <mhnazly@programmer.net>
wrote:

>I am trying to build a web based system using asp.net and
>sql server.
>I would like to know on how to dynamically create a
>webpage from a webpage, and at the same time dynamically
>create the database in the back end.
>For instance, there is a maintenance page in the client
>side where user can add new webpages and automatically
>created the database for the new type of data in the new
>webpages.

I'll leave off the discussion of what data and whether you want a new
database or just a table, but since you mentioned SQL Server your job
is rather simple. A SQL query with a CREATE DATABASE will do the job
you are asking about, you may want to check a SQL group or the SQL
Books Online for specifics of the syntax.

Jeff

[Bullschmidt]

You may also have luck asking ASP.NET questions here:

Newsgroup:
microsoft.public.dotnet.framework.aspnet

SitePoint .NET Forum
[url]http://www.sitepointforums.com/forumdisplay.php?s=&daysprune=1000&forumi[/url]
d=141

ASP Messageboard - ASP.NET Forum
[url]http://www.aspmessageboard.com/forum/aspplus.asp[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!