VS 2015连接SQL server数据库方法

vs新建一个Windows窗口应用程序，界面布局如下：

 

Form1.cs中代码如下：

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Data;
  5 using System.Drawing;
  6 using System.Linq;
  7 using System.Text;
  8 using System.Threading.Tasks;
  9 using System.Windows.Forms;
 10 
 11 using System.Data.SqlClient;
 12 
 13 namespace smSQLServerTest
 14 {
 15     public partial class MainForm : Form
 16     {
 17         public MainForm()
 18         {
 19             InitializeComponent();
 20         }
 21 
 22 
 23 
 24         //定义一个数据库连接对象
 25         SqlConnection myconnection;
 26 
 27 
 28         //连接按钮
 29         private void btConnect_Click(object sender, EventArgs e)
 30         {
 31             try
 32             {
 33                 myconnection = new SqlConnection("Integrated Security=SSPI;Initial Catalog=yinming_ceshi;Data Source=PC-20170607UIQI;User ID=PC-20170607UIQI\\Administrator;");
 34                 myconnection.Open();     //打开数据库
 35                 label1.Text = "数据库连接成功！";
 36             }