表示 进入内容 11
Displaying posts with tag: C Sharp (reset)
Connection To SQL Server

Connection To SQL Server

How to use C# to connect to the SQL Server, there is a connection string we can use:

      string conn = "Integrated Security=false; Data Source=****;Initial Catalog=****;User ID=****;Password=****";

Data Source (Server; Address ; Addr ; Network Address): The name or network address of the instance of SQL Server to which to connect. The port number can be specified after the server name:
server=tcp:servername, portnumber
When specifying a local instance, always use (local).
Initial Catalog (Database): The name of the database.
Integrated Security (Trusted_Connection): By default, it is false, and User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.

To ensure that connections are always closed, open the …

[获取更多]
表示 进入内容 11