How can i make my winform project shareable? (how can i set the database to the project folder?)

Question

I made a C# winform project in visual studio for a school exam and i want to share it with my teacher, but when i open it in another pc it doesn't work. The main problem is that the database path is set to the documents folder and i dont know how to set the database to the project folder to make the project shareable. Thanks in advance!

Now its looks like this:

SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=\\Mac\Home\Documents\Raktarkeszletdb.mdf;Integrated Security=True;Connect Timeout=30");

Sorry i'm very new in programming, how can i do this exactly? — Morpheus, May 09 '21 at 08:57
You would need to construct the database path using `Path.Combine` and `Environment.CurrentDirectory`. But you are best off putting the database on a proper server, see https://stackoverflow.com/questions/11178720/whats-the-issue-with-attachdbfilename — Charlieface, May 09 '21 at 09:48
Does this help? https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/connection-strings-and-configuration-files — Klaus Gütter, May 09 '21 at 10:35

score 0 · Answer 1 · answered May 10 '21 at 16:51

Instead of

SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=\\Mac\Home\Documents\Raktarkeszletdb.mdf;Integrated Security=True;Connect Timeout=30");

You need to write something like this:

var projectFolder = AppDomain.CurrentDomain.BaseDirectory;
var connectionString = string.Format(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename={0}\Raktarkeszletdb.mdf;Integrated Security=True;Connect Timeout=30", projectFolder);   
var con = new SqlConnection(connectionString);

See also best way to get application folder path.

How can i make my winform project shareable? (how can i set the database to the project folder?)

1 Answers1