p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ADO.NET (http://p2p.wrox.com/forumdisplay.php?f=109)
-   -   how to create data base at run time (http://p2p.wrox.com/showthread.php?t=41316)

al-hijjawi April 15th, 2006 10:34 AM

how to create data base at run time
hello every body
i am working in an e-mall project and i must create database for each store in my mall , the problem is that i will create the databases for the stores at the run time (i.e when the store owner click a command button in an ASP.NET page), what the ADO.NET statments i can use here ????
(i am use ASP.NET with VB.net)
and thanks

Imar April 16th, 2006 08:11 AM

Hi there,

This largely depends on the type of database you want to create.
If you need a Microsoft Access database, take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=143

If you want to create a SQL Server database, you can execute DDL commands, like CREATE DATABASE, CREATE TABLE etc against an open connection.


Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

al-hijjawi April 16th, 2006 09:55 AM

thank you Imar
you help me too much
i am want sql server database so i am use create database and create table statments as you said
and every thing is 100%
thank you again

All times are GMT -4. The time now is 04:55 PM.

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