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

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

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