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................
Loading
Dipa AhujaPosted Jan 27, 2010, 12:26 PM
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 SurendranPosted Jan 27, 2010, 5:08 AM
"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 MPosted Jan 27, 2010, 4:40 AM
------------------
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