appconfig /connectionString

hi
Let Me Explain

There is Beautiful Class Available in C# Windows To Detect Application Path Where The exe Gets installed

System.Windows.Forms.Application.StartupPath.ToString();

That Returns The Path As A String For Ur Application.U Just Append That mdf file name to The string.

example
=====

string constring=System.Windows.Forms.Application.StartupPath.ToString();

I Think it Resolves Ur Requirement.

feedback Always Expected

BangaruBabu Pureti

Hi , to fix my problem I simply


use this

connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|CLU_OpDatabase.mdb"

so now im forcing the users to run the database where the exe is. which is what i prefer for this situation

you can place this line on your application startup form file for example if you are using any login form than you can place this line on login form load event or you can use in program.cs file.
thanks

also if im using this line of code below  , where to place this in the cs. file     

AppDomain.CurrentDomain.SetData("DataDirectory","C:\\Data\\bin\\Debug\\");

hello Darnell
try this:
|DataDirectory| is a substitution string that indicates the path to the database.
By default, |DataDirectory| is substituted with the base directory that the exe is running from.
you can set the custom path of its byusing this code(use this code on load time of your application):
AppDomain.CurrentDomain.setData("DataDirectory","C:\\Data\\bin\\Debug\");
 
and than write this connection string in your appconfig:
"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Cif_Clu_Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

 
thanks
please mark as answere if you like my answere

Hi I found out the situation for some reason when i did a setup and deply my mdf. got erase, so thats why i probably could not connect, i went back to the actual folder and it was there.

do i change it this way? 

[global::System.Configuration.DefaultSettingValueAttribute("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Data\\bin\\Debug\\Database.mdf\";Integrated Security=True;Conne" +
            "ct Timeout=30;User Instance=True")]

and then in the appconfig I do this

 connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Cif_Clu_Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
      providerName="System.Data.SqlClient" />


how can i set it up to where they can just run the exe anywhere on the computer, what if they wanted to run the exe on the desktop, that mean they would to create a datafolder i dont want to do that,

just want to run from anywhere.

hi friend,
AttachDbFilename="\Data\Database.mdf";

Either create a folder names Data in the same folder where the exe is and set the path like this then you don't have to change the path every time you installed it.
Hope it helps you.

Its not changing, Im saying when I released my software to the user on another computer, what path to give the appconfig, I wont the user to have to go to the appconfig and change the path, I want to the user to just simply run the code and appconfig should reference the the correct mdf according to the location of the exe im guessing