
In this article, you can see Microsoft SQL Express Database Connection String in C#
Microsoft SQL Express Database ConnectionString in C#:
ConnectionString provides the required information to the driver that tells where to find the default connection information. Optionally, you are allowed to specify attribute=value pairs in the connection string to override the default values stored in the data source.
1. .NET Data Provider – Standard Connection with default relative path
using System.Data.Odbc; using System.Data.SqlClient; var conn = new SqlConnection(); conn.ConnectionString = "Data Source=.\SQLExpress;" + "User Instance=true;" + "User Id=UserName;" + "Password=Secret;" + "AttachDbFilename=|DataDirectory|DataBaseName.mdf;" conn.Open();
2. .NET Data Provider – Trusted Connection with default relative path
using System.Data.Odbc; using System.Data.SqlClient; var conn = new SqlConnection(); conn.ConnectionString = "Data Source=.\SQLExpress;" + "User Instance=true;" + "Integrated Security=true;" + "AttachDbFilename=|DataDirectory|DataBaseName.mdf;" conn.Open();
4. .NET Data Provider – Standard Connection with custom relative path
using System.Data.OleDb; using System.Data.SqlClient; AppDomain.CurrentDomain.SetData("DataDirectory", "C:\MyPath\"); var conn = new SqlConnection(); conn.ConnectionString = "Data Source=.\SQLExpress;" + "User Instance=true;" + "User Id=UserName;" + "Password=Secret;" + "AttachDbFilename=|DataDirectory|DataBaseName.mdf;" conn.Open();
5. .NET Data Provider — Trusted Connection with custom relative path
using System.Data.OleDb; using System.Data.SqlClient; AppDomain.CurrentDomain.SetData("DataDirectory", "C:\MyPath\"); var conn = new SqlConnection(); conn.ConnectionString = "Data Source=.\SQLExpress;" + "User Instance=true;" + "Integrated Security=true;" + "AttachDbFilename=|DataDirectory|DataBaseName.mdf;" conn.Open();
6. NET Data Provider – Standard Connection with absolute path
using System.Data.OleDb; using System.Data.SqlClient; var conn = new SqlConnection(); conn.ConnectionString = "Data Source=.\SQLExpress;" + "User Instance=true;" + "User Id=UserName;" + "Password=Secret;" + "AttachDbFilename=C:\MyPath\DataBaseName.mdf;" conn.Open();
7. .NET Data Provider – Trusted Connection with absolute path
using System.Data.SqlClient; using System.Data.SqlClient; var conn = new SqlConnection(); conn.ConnectionString = "Data Source=.\SQLExpress;" + "User Instance=true;" + "Integrated Security=true;" + "AttachDbFilename=C:\MyPath\DataBaseName.mdf;" conn.Open();
– Article ends here –
In this article, you can see Microsoft Sql Express Database Connection String in C#. Check out the code snippets and integrate into your code.
In this article, I have listed C# code snippets of connection string for Text Database.Text Database Connection String in C#: Connection String provide ...
In this article, I have listed C# code snippets of connection string for Excel Database.Excel Database Connection String in C#: Connection String ...
In this article, I have listed C# code snippets of connection string for Informix Database.Informix Database Connection String in C#: Connection String ...
In this article, I have listed C# code snippets of connection string for Interbase Database.Interbase Database Connection String in C#: Connection ...
In this article, I have listed C# code snippets of connection string for Sybase Database.Sybase Database Connection String in C#: Connection String ...
In this article, find out list of MySql database connection string with C# code snippets. In this article you can see how to create connector.NET connection ...
In this article, I have listed C# code snippets of connection string for IBM DB2 Database.IBM DB2 Database Connection String in C#: Connection String ...
In this article, I have listed C# code snippets of connection string for Oracle Database.Oracle Database Connection String in C#: Connection String ...
In this article, I have listed C# code snippets of connection string for Microsoft Access Database.Microsoft Access Database Connection String in C#: ...