C#
C#

help

Root Question Message

9 Merlin engines
9 Merlin engines2/19/2023
❔ C# Need help with changing SQL connection string

I got a program which has database in it but I can't run it properly as I don't know how to change the SQL connection string. Please help me
OneWholesomeDev
OneWholesomeDev2/19/2023
Dispose your sql connection, and prob your adapter as well
9 Merlin engines
9 Merlin engines2/19/2023
<configuration>
<connectionStrings>
<add name="ETCDatabase" connectionString='Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="D:\Users\James\Downloads\ETCWinFormsApp\ETCDatabase.mdf";Integrated Security=True'
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
OneWholesomeDev
OneWholesomeDev2/19/2023
connection string I assume to be fine
9 Merlin engines
9 Merlin engines2/19/2023
Someone shared the program to me and do I have to change the SQL connection string accordingly to run the program?
OneWholesomeDev
OneWholesomeDev2/19/2023
Does the path to that file / the file exist?
9 Merlin engines
9 Merlin engines2/19/2023
Oh yea I have the file and the path to it
9 Merlin engines
9 Merlin engines2/19/2023
I was looking for it
9 Merlin engines
9 Merlin engines2/19/2023
@802050521388941314
9 Merlin engines
9 Merlin engines2/19/2023
do i have to change the file path?
OneWholesomeDev
OneWholesomeDev2/19/2023
if the file path is the same as your config, then no
9 Merlin engines
9 Merlin engines2/19/2023
ok i have just fixed the database file path
9 Merlin engines
9 Merlin engines2/19/2023
now it shows another problem
9 Merlin engines
9 Merlin engines2/19/2023
OneWholesomeDev
OneWholesomeDev2/19/2023
Now your connection string is borked
9 Merlin engines
9 Merlin engines2/19/2023
I changed my sql connection string from this
9 Merlin engines
9 Merlin engines2/19/2023
To this:
9 Merlin engines
9 Merlin engines2/19/2023
<configuration>
<connectionStrings>
<add name="ETCDatabase" connectionString='Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="D:\IOOP\ETCWinFormsApp_20230219\ETCWinFormsApp\ETCDatabase.mdf"Integrated Security=True'
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
9 Merlin engines
9 Merlin engines2/19/2023
===================
9 Merlin engines
9 Merlin engines2/19/2023
"D:\IOOP\ETCWinFormsApp_20230219\ETCWinFormsApp\ETCDatabase.mdf"
9 Merlin engines
9 Merlin engines2/19/2023
this is the path to the file i copied from file explorer
OneWholesomeDev
OneWholesomeDev2/19/2023
Youre missing a semicolon
9 Merlin engines
9 Merlin engines2/19/2023
ohh god
9 Merlin engines
9 Merlin engines2/19/2023
hang on
9 Merlin engines
9 Merlin engines2/19/2023
@802050521388941314 Thanks lots
OneWholesomeDev
OneWholesomeDev2/19/2023
:Ok:
9 Merlin engines
9 Merlin engines2/19/2023
😭😭🙏🏻🙏🏻
ContactFrequently Asked QuestionsJoin The DiscordBugs & Feature RequestsTerms & Privacy