C# with MS SQL DB interaction

Question

0.00/5 (No votes)

See more:

Dear Experts,

I'm writing an C# application which will dynamically create and interact with MS SQL DB (.mdf file). From some source in net i came to know that to create DB and execute Query I need to install MS SQl Server 2008 or 2005 ( in my case requirment is MS SQL Server 2008).

My Question is that
1. Can we provide the SQL libraries during installation of our application?
2. If So, Cann't i create and execute the SQL Query if i've only SQL libraries in my system?

Thank you all in advance.

Posted 27-Apr-12 1:31am

vidiking

Add a Solution

Comments

bbirajdar 13-May-12 11:28am

Before creating a DB , you need to install the SQL server , either on the same machine or on another machine on the network. Because the DB is created IN the sql server.

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)

Mehdi Gholam · Answer 1 · 2012-04-27T01:34:00

Solution 1

Microsoft SQL connection libraries are part of .net, so you do not need to do anything but install .net on your target machine if they don't already have it.

Posted 27-Apr-12 1:34am

Mehdi Gholam

Comments

vidiking 27-Apr-12 7:44am

Thank you mehdi. But to create a DB i need the connection string some thing like
"Server=SI-MYLOCALSYSTEM;User ID=sa; Password=pwd; database=master".
so if i wont install SQL Server, how can i know what is the User Id and Password.
N.B. I'm planning to show a dialog and ask user to provide user id and password.

Mehdi Gholam 27-Apr-12 7:46am

Installing SQL server is a different matter which must be done with your installation or skipped if already exists (i.e. user selected server for your db).

Your "..server=xxxxx" will be the name or the IP address of that server.

vidiking 27-Apr-12 7:55am

I can give server=myip, but what should i provide for User Id and password in connection string to open connection like

SqlConnection myConn = new SqlConnection("Server=SI-MYLOCALSYSTEM;User ID=sa; Password=pwd; database=master");
myConn.Open();

Mehdi Gholam 27-Apr-12 8:06am

This should be done at runtime through configuration or a dialog box where the user can enter the server name or IP address.

Maciej Los · Answer 2 · 2012-05-13T05:26:00

1. Can we provide the SQL libraries during installation of our application?
As Mehdi Gholam wrote: No, you don't.

2. If So, Cann't i create and execute the SQL Query if i've only SQL libraries in my system?
No, you can't. You need to install MS SQL Server[^] on local computer, unless you have a permission to the MS SQL server in network.

vidiking · Answer 3 · 2012-05-13T03:15:00

Solution 2

Dear All,

Please help me.
For creating db in Loacl MS Server (.mdf file), do i need to install the server.

Posted 13-May-12 3:15am

vidiking

Comments

Maciej Los 13-May-12 11:21am

This is not a solution!. Please, remove it and update your question - use "Improve question" button.

Yes, you need to install SQL server (on local system or in network).

C# with MS SQL DB interaction

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us