0

I'm new to coding. I'm attempting to access a SQL Server file through WPF / C# and I am having trouble getting in the correct string, I believe. I do not yet fully understand SQL logins, but here is the code I have now, which I believe as close to correct as I can get on my own:

string CS = @"Data Source=(LocalDB)\v11.0; Integrated Security=true; AttachDbFileName=C:\Users\Madison\source\repos\TheRealStudyBot\TheRealStudyBot\TestingData.mdf";

SqlConnection con = new SqlConnection(CS);

SqlCommand cmd = new SqlCommand("CREATE TABLE table1 (PK int, Name nvarchar(255), PRIMARY KEY *PK),);", con);

con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
con.Close();

This code is under public MainWindow(), after InitializeComponent(). The file path should be correct. The database is empty. I get this exception:

Win32Exception: Unknown error (0x89c50118)

Ran it once more and I think I may have accidentally altered my debug settings because now it also provides a window stating

The solution does not contain the specified document

(along with plenty of other jargony-code-exception-results-text). I don't see where I'm going wrong. Please help!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Madison Roby
  • 5
  • 2
  • Ah, but _"jargony-code-exception-results-text"_ is often very useful. Include it as textbin your question. This might help: https://stackoverflow.com/questions/928813/connection-string-to-connect-to-mdf – Flydog57 Jan 05 '22 at 04:28

1 Answers1

0

If you are on Visual Studio 2019,

  1. Double Click on your LocalDB which opens Server Explorer
  2. Clicking on your database, On the properties tab shows the connection string.
  3. Copy that & Paste on CS!

And the Normal Connection String Format For LocalDB is,

Data Source=Your_DataSource;Initial Catalog=YourDatabaseName;Integrated Security=True;Pooling=False
Opus Corpus
  • 115
  • 1
  • 8