need help attaching database automatically

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

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[^]

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);
           }

       }

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).

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