Creating a new database in a program

[Ming_Lei]

How do I create a new database and some tables using C#?

 

- Thanks.

[PlausiblyDamp]

What database are you using?

[Ming_Lei]

I am using Access database. Thanks!!

Or is there a better type of database I should be using??

[PlausiblyDamp]

http://www.xtremedotnettalk.com/showthread.php?t=86228&highlight=create+access+database

May be worth a look

[Ming_Lei]

I've read and now can create tables. Thanks!!

But here I got error when I try the following code to create database:

==========================

OleDbConnection conn1 = new OleDbConnection();

conn1.Open();

 

string cmdstr = "create database MyDatabase";

OleDbCommand cmd = new OleDbCommand(cmdstr, conn1);

cmd.ExecuteNonQuery();

====================================

 

Obviously there are several problems in there. But where are they??