Create Database in Runtime as first execution

Question

0.00/5 (No votes)

See more:

Hello everybody,

As I said in a previous post, I am learning VB.net and I like it very much.

Now I have arrived at the database part. In all books I have and all tutorials I found all the examples of making a database are explained creating database from
Visual Studio. The problem is, I would like my application when it runs for the first time to create a new and empty database file with all Fields and Keys.

How I did during the design. Now I am looking for to make a simple database with fields like:

Name as string, Country as String, codes as string or Array.

So can some help me to find the solution? Can you please send the code?

Also I saw that it could be possible using vb.net code and/or MySql. It would be very interesting to see the difference.

Please help Me
Jorkax

Moved from answer:
Hi everybody,
can someone help me?
I need to study the code in vb.net to create a simple local database.
I am sorry if I did not understand previuos examples.
what I need?
1 - a simple connection strings ( maybe I can use the visual studio wizzard )
2 - Vb.net code ( not using MySql ) to create local database ( even the file *.mdf )
3 - how to create a table a differnt kind of fields
I found many examples on line but not as clear as I look for ( http://www.vb-helper.com/howto_net_runtime_dataset.html )
please help me
you may contact me even personally
I can recognize your help
Thank you

Posted 24-Jan-11 4:55am

jorkax

Updated 28-Jan-11 0:49am

Manfred Rudolf Bihy

v3

Add a Solution

Comments

Manfred Rudolf Bihy 28-Jan-11 6:50am

Moved OP's answer into the question.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nish Nishant · Answer 1 · 2011-01-24T05:24:00

Most databases come with clients that will generate the required SQL for you, which will crate the tables, views, stored procs etc. On first run, you basically need to execute this auto generated SQL on the target database server.

It's also possible to include actual table data in the SQL (if you wish to input some initial data).

Alternatively, you can create a backup of the default DB and restore it during installation (on the target machine). Different databases call this by different terms though, SQL server uses backup/restore. MySQL may use similar terminology (google it out).

Kschuler · Answer 2 · 2011-01-24T05:39:00

You mentioned MySql, but didn't say it was a requirement...so I thougth I'd point out this Tip/Trick that has several methods for creating an access/Jet database file:

Create a blank Jet database[^]

But in general what you are asking should be possible in virtually any language and with a variety of different types of databases. Once you get the blank database you just need the proper SQL to build the files...for example, this would build a table like what you are asking in an access db:

CREATE TABLE myTable(
  Name TEXT (80) NOT NULL DEFAULT='', 
  Country TEXT (80) NOT NULL DEFAULT='',
  Codes  TEXT (20) NOT NULL DEFAULT=''
);

You should research the SQL Create Table Statement[^].

Eduard Keilholz · Answer 3 · 2011-01-24T20:35:00

Hey guys!

Ofcourse this is possible, I would however recommend you track your changes using SQL Scripts. Those scripts contain all changes you've made in your development environment. If you run those scripts, your database will be reproduced, which sounds like exactly what you want.

To create a new database, and run the scripts, you may want to use SQL Server Management Objects (SMO)

ServerConnection serverConnection = new ServerConnection();
serverConnection.ConnectionString = ConnectionString;
serverConnection.Connect();

Microsoft.SqlServer.Management.Smo.Server sqlServer = new Microsoft.SqlServer.Management.Smo.Server(serverConnection);
                
Database createdDatabase = new Database();
createdDatabase.Name = DatabaseName;
createdDatabase.Parent = sqlServer;
createdDatabase.Create();
databaseCreated = true;

serverConnection.Disconnect();

Good luck!

Create Database in Runtime as first execution

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0