SqlConnection SqlCon = new SqlConnection("Server=(local);Database=pubs;Trusted_Connection=True");

hi, this is a working connection string in my project.

Can i in any way specify the location of the database on my pc ,like "location =C:\testdb\..." in the above connection string.(For SQL Server 2008)

Also can we also specify of the location of the .mdf file(or any other) which can then be used to access data.

constr=@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\..\\RightAccess.accdb";

just pass this string along with OleDb connection obeject to OleDb command.

I wanted Data Soruce path which was indepedent of the machine.The above one is a relative path , relative to the folder were you have installed the programme.


I believe same works for SqlConnection.


Thanks

Do you mean when you deploy the project? Are you using ClickOnce or a Setup & Deployment package?

Or are you speaking generally about how to connect to a database?

RobinDotNet

constr=@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\..\\RightAccess.accdb";

just pass this string along with OleDb connection obeject to OleDb command.

I wanted Data Soruce path which was indepedent of the machine.The above one is a relative path , relative to the folder were you have installed the programme.


I believe same works for SqlConnection.


Thanks

You might want to post your question in the C# forum next time. This is a forum for the deployment of .Net applications.

RobinDotNet