Connect to SQL Server

最新推荐文章于 2023-02-07 21:29:17 发布

cuchen935177

最新推荐文章于 2023-02-07 21:29:17 发布

阅读量487

点赞数

文章标签：数据库 c#

using System;
using System.Data;
using System.Data.SqlClient;

namespace MySqlConnection
{
class MainClass
{
  public static void Main()
  {
   string connectionString = "server=someserver;database=Northwind;uid=sa;pwd=sa";
   SqlConnection cnt = new SqlConnection(connectionString);

   cnt.Open();

   // Display properties of cnt object
   Console.WriteLine("ConnectionString: " + cnt.ConnectionString );
   Console.WriteLine("ConnectionTimeout: " + cnt.ConnectionTimeout);
   Console.WriteLine("Server Name: "       + cnt.DataSource       );
   Console.WriteLine("Server Version: "    + cnt.ServerVersion    );
   Console.WriteLine("Database Name: "     + cnt.Database         );
   Console.WriteLine("WorkstationID: "     + cnt.WorkstationId    );
   Console.WriteLine("State: "             + cnt.State  );

   cnt.Close();

   Console.ReadLine();
  }
}
}