creating database..

[PT Exorcist]

is it possible? i think yes..but how to do it? i have in my computer some of them like northwind..but how do i create an empty database so i can fill it up with my things?

tks in advance

[Pirate]

Hmm , using code ?

[Edneeis]

What kind of database? Access? SQL?

If its sql then you can use the CREATE DATABASE command. Of course there is a little more to it than that, try checking the Books Online bit for a good example.

With Access I'm not really sure, its been too long. I know you can us ADOX to make a new database or table. You might be able to use one of the Schema methods in OLEDB ADO.NET.

[PT Exorcist]

sorry for not being explicit, i am talking about sql server, and it doesnt need to be by code, after thinkin for a while if it could be not for code it'd be even better

[PT Exorcist]

i think i did it thru the toolbox!!!!!!
i made:

Servers -> sql servers > branco\netsdk\ *new database*
i had tried this before but it gave some strange error..anyways..this is the way to create a new sql database isnt it?

also i think i've heard that it is possible to create local databases...i mean databases that are in the same dir as the app..how to achieve this?

[Edneeis]

With SQL you can't control where the databases are stored also the databases aren't one single file and portably like that as Access databases are. Sure you can use the Server Explorer to make databases and work with MSDE database on the local machine. Unless you have higher than Pro version, which allows you to do the same on different machines or running SQl Server itself. If you are/were using SQL Server you can also use the Enterprise Manager tool but it doesn't come with MSDE. You can also do the same with MSDE and Access 2000 or higher via 'Projects'.