SQL connection string

Question

hai expert please help me......
I am using SQL server managent studio express and c# for windows application...i have copied my data base to bin..I am using the following connection string..but it is not taking the database from bin.
SqlConnection  con=new SqlConnection( "Data Source=.\\SQLEXPRESS;Initial Catalog=dbRDAgent;Integrated Security=SSPI");
Plaese give me the connection string for establishing a connection to the database in bin.
thanks in advance................

Answer 1

hi.. i think you should use application path.. coz in my case it work
as ur r using E:\\rd\\27-1-2010\\Sep-21\\RDAgent\\bin\\Debug\\dbRDAgent.mdf;
i use this way :
public static string con = "Data Source=.\\SQLEXPRESS;Integrated Security=true;User Instance=true;AttachDbFilename=|DataDirectory|/Database1.mdf;Database=Database1.mfd;";

Answer 2

thanks ...but if i am using this connection string, its not connecting to the database in bin.....but when i am using the following string its work correctly
"Data Source=.\\SQLEXPRESS;AttachDbFilename=E:\\rd\\27-1-2010\\Sep-21\\RDAgent\\bin\\Debug\\dbRDAgent.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
but its not working when running on another system....
please help.....

Answer 3

use this code sample
------------------

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;

class MainClass
{
    public static void Main()
    {
        using (SqlConnection con = new SqlConnection())
        {
            con.ConnectionString ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;";    

            con.Open();

            if (con.State == ConnectionState.Open)
            {
                Console.WriteLine("SqlConnection Information:");
                Console.WriteLine("  Connection State = " + con.State);
                Console.WriteLine("  Connection String = " + con.ConnectionString);
                Console.WriteLine("  Database Source = " + con.DataSource);
                Console.WriteLine("  Database = " + con.Database);
                Console.WriteLine("  Server Version = " + con.ServerVersion);
                Console.WriteLine("  Workstation Id = " + con.WorkstationId);
                Console.WriteLine("  Timeout = " + con.ConnectionTimeout);
                Console.WriteLine("  Packet Size = " + con.PacketSize);
            }
            else
            {
                Console.WriteLine("SqlConnection failed to open.");
                Console.WriteLine("  Connection State = " + con.State);
            }
        }

    }
}

For connection info
--------------
http://www.triconsole.com/dotnet/sqlconnection_class.php
http://www.connectionstrings.com/sql-server-2005
http://authors.aspalliance.com/aspxtreme/sys/data/sqlclient/sqlconnectionclass.aspx