need help attaching database automatically

Question

4.00/5 (2 votes)

See more:

Hi,
I have an existing data base and I want it to be automatically attached to my program, no matter during the installation process or when the user runs my project. I just want it to be done(attached automatically)

I'm using C#.NET and the name of my database is "MyLibraryDataBase".

I think I should put some code in the main page of my project in the event of form_load

,thanks ;)

Posted 25-Aug-11 12:15pm

hrhm_04

Updated 26-Aug-11 0:08am

CPallini

v2

Add a Solution

6 solutions

Solution 2

Ok, so there is still no answer on this..
I'm also wondering how to do this!

Posted 25-Aug-11 23:32pm

Ben Paxton

Comments

hrhm_04 26-Aug-11 14:55pm

Take a look at the code I put.

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)

hrhm_04 · Accepted Answer · 2011-08-26T08:59:00

Hello Friends, I think I found the answer and here it is. I wrote this code in the event of clicking a button named attach database:

private void BTNAttach_Click(object sender, EventArgs e)
       {

           try
           {
               SqlConnection con = new SqlConnection();
               con.ConnectionString = "Data Source=(local);Initial Catalog=master;Integrated Security=True";
               con.Open();

               string str = "use master;" +
              "EXECUTE sp_attach_db @dbname = N'MyLibraryDataBase' , " +
                " @filename1 = N'" + System.Environment.CurrentDirectory + "\\Data\\MyLibraryDataBase.mdf'," +
                "@filename2 = N'" + System.Environment.CurrentDirectory + "\\Data\\MyLibraryDataBase_log.ldf'";

               LAMDFSQLAdress.Text = System.Environment.CurrentDirectory+"\\Data\\MyLibraryDataBase.mdf";
               LALOGSQLAdress.Text = System.Environment.CurrentDirectory + "\\Data\\MyLibraryDataBase_log.ldf";



               SqlCommand cmd = new SqlCommand(str, con);
               cmd.ExecuteNonQuery();
               con.Close();
               MessageBox.Show("DataBase Successfully Attached.");
           }

           catch (Exception x)
           {
               if (x.Message.IndexOf("already exists") >= 0)
                   MessageBox.Show("DataBase already exists.");
               else
                   MessageBox.Show(x.Message);
           }

       }

DanHodgson88 · Accepted Answer · 2011-08-25T23:58:00

Solution 5

I think everyone's missing the question here a bit correct me if im wrong but are you looking for publishing the program to multiple PC's and then each instance of the program has its own database?

try:

http://msdn.microsoft.com/en-us/library/ms228283(v=vs.80).aspx[^]

Posted 25-Aug-11 23:58pm

DanHodgson88

Updated 25-Aug-11 23:59pm

v2

Comments

hrhm_04 26-Aug-11 14:45pm

Yes that right! I dont want to attach the database on every pc manually!

Herman<T>.Instance · Accepted Answer · 2011-08-25T23:43:00

Solution 4

you can set the connection string in your config-file. You can use that to connect to a database. In my article Disadvantages of SqlParameters Turned into Advantages[^] you can find a method that finds your defaultconnection in your config file

Posted 25-Aug-11 23:43pm

Herman<T>.Instance

Ben Steele · Accepted Answer · 2011-08-25T23:39:00

if i'm reading this correctly, you are wanting the software to only connect to one database?

Why not set up the database name as a textbox field where the text defaults to "MyLibraryDataBase", pass that to a variable that is then used in your code to connect to your database, that way you can always change it at a later date if you need to but will always default to "MyLibraryDataBase" if nothing is specified?

#realJSOP · Accepted Answer · 2011-08-25T12:42:00

Solution 1

You only need to connect to it when you want to retrieve or add/insert data. Other than those two instances, the connection shouldn't be open.

EDIT ====================

If I understand your comment, you're talking about the actual Visual Studio project? Unless your database is on a remote computer that is also accessible by the other system, this isn't possible unless you export the database and give them a SQL script they can run to build/update their own copy (there are also other considerations that I probably won't remember all of).

Posted 25-Aug-11 12:42pm

#realJSOP

Updated 26-Aug-11 2:16am

v2

Comments

hrhm_04 25-Aug-11 19:57pm

Hi,
I know what you say:) but this is not my problem.
I want my database to attach automatically to my project when the user runs the project, you know, when I install it on another pc, the database isn't attached and the project cant use it.

thanks John ;)

walterhevedeich 25-Aug-11 20:30pm

So, do you mean, each application that will be installed will have its own database? Or do you mean, you want the application to have a connection to a central database when you install it? Which is which?

hrhm_04 26-Aug-11 14:50pm

you know, i give a sql database with the program. in my pc the database is attached.But in other pc's it is not, I think it is because my sql adress is different from others. i found my answer. Take a look at the code i put.Thanks ;)

need help attaching database automatically

6 solutions

Solution 7

Solution 5

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0