Database installation during C# project setup urgent help required :)

Question

0.00/5 (No votes)

See more:

SQL-server-2000

, +

Hello,
I have created a project in C# GUI and database i used is SQL SERVER 2000, i have cretaed a database named "maso" and it contains around 7 tables and in some tables i am inserting data by opening the IDE of SQL SERVER 2000 now what i want is that during the set up i.e when my project is being installed at the clients computer i want the maso database to be installed at the same time not only this maso contains an admin table in which i am inserting data by writing the following piece of sql code:

insert into admin values('radix',123);

this query must also be executed at the same time is this possible please help me out

Thank You;
Radix

Posted 15-Mar-10 2:01am

radix3

Add a Solution

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)

Ankur^\m/ · Answer 1 · 2010-03-15T02:26:00

I don't know what you are trying to do.
Why are you installing SQL Server on the client?
There must be a dedicated database server (at least), so that every client can connect to a common database.
Do you have only ONE client?
If this is the case, there are many option for storing data.
If you want to use SQL Server only, you include a SQL Server CE Database file. Create tables and save the data into the database before doing a release build.

Hope this helps!

#realJSOP · Answer 2 · 2010-03-15T02:50:00

Using Sql Manager Express (free util from MS), export your database to a script, and then...

0) Embed the script as a resource in an appropriate assembly.

1) When your program starts up, try to connect to the database.

2) If it's not there (the SqlConnection.Open() method throws an appropriate exception), have your program extract and run the script to create it. Then, delete the script file from th disc.

3) Retry the connection

TheIdleProgrammer · Answer 3 · 2010-03-15T03:11:00

Solution 3

Perhaps you could create an SQL Server Compact Edition database to ship with your product? You can create it from scratch using a bunch of queries either at installation or in advance, or you could use a third party tool to create a CE database from your server based database.

Posted 15-Mar-10 3:11am

TheIdleProgrammer

Database installation during C# project setup urgent help required :)

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0