How to connect to SQL Server data without using SQL Server Management Studio in C# ?

ask: is it possible to connect SQL Server data according to file connection type, just like in microsoft access data connection
public static string sConnectionString = @ "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + @ "| DataDirectory | \ data.mdb" + "; Persist Security Info = False; Jet OLEDB: Database Password = 123";

How do you convert the above access connection into sql server connection ?

Have a look at https://www.connectionstrings.com/ol...or-sql-server/

Quote:

---

Originally Posted by Zikkarro

Did you solve it?

---

If you asked me then yes. I did solve this "problem" many years ago wenn I began to use SQL Server.

I have the same problem that you have, then I research and I find a solution to this website
https://www.guru99.com/c-sharp-access-database.html