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

Dipa Ahuja · Answer

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

Soumya Surendran · Answer

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

Lalit M · Answer

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