Create Database using C#

Question

0.00/5 (No votes)

See more:

Create Database Using C#

Hi,

I write software in C# that should create (by itself) a new database.
The SQL server should be installed on the customer's computers silently
(I still need to figure how to do this part)
How can my software create a database that only it can access? Do I
need to create a special user account from the software?
What user account do I use to open a connection to the SQL server in
the first place when I create the database (taking under consideration
that the SQL server was installed silently and as far as the user
concern he has no idea my software uses SQL server).

To summarize:
1.The install of my software should install and configure the SQL
server silently (appreciate any help here)
2.The software needs to access the local SQL server and create a
database that only it can access when the software runs

Posted 5-Jun-11 3:52am

amsainju

Add a Solution

3 solutions

Solution 1

You should not install SQL server on the customer computer: the only version you could install is the Express version - all the others need to be paid for - and they may have it installed already on another server. Instead, ask your user, and point him at where to get the express version if he doesn't have it yet.

Posted 5-Jun-11 3:59am

OriginalGriff

Solution 3

I think you should try XML databse system.

Posted 6-Jun-11 7:35am

vilasnirgude

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)

Monjurul Habib · Accepted Answer · 2011-06-05T08:09:00

Solution 2

This is illegal.You are not authorized to install another Microsoft product with your program.

Install sql server database with visual studio setup

Posted 5-Jun-11 8:09am

Monjurul Habib

Comments

amsainju 5-Jun-11 14:25pm

hey i visited
http://msdn.microsoft.com/en-us/library/49b92ztk%28v=VS.90%29.aspx#Y1075
for my solution i did as stated in the page with little modification in the code to manange the problem that occur with different version of .net framework...
at the end the whole code didn't show any error but when i executed the output the following error occured in the middle of the execution
Error 1001.Object reference not set to an instance of an object

if you like to see the code i did i can send you in your email...

Monjurul Habib 21-Jul-11 17:32pm

sounds great..thumbs up.