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.

HtH,

Imar
---------------------------------------
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.