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

SQL connection string

Rashid Khan

Suthish Nair

Krishna Garad