C#检测数据库的是否连接成功

首先先建立连接还有登录名和密码。。

代码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;


namespace WindowsFormsApplication3
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


        private void button1_Click(object sender, EventArgs e)
        {
            String strconn = "Data Source = wwh; Initial Catalog = myDatalog = myDatabase; uid = sa; pwd = sa";
            SqlConnection conn = new SqlConnection(strconn);
            try {


                int i1, i2;
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "update BaseInfofrom set[name] = 'myName' where[No] = 3";


                i1 = cmd.ExecuteNonQuery();
                cmd.CommandText =  "delete from BaseInfrom where No = 2";
                i2 = cmd.ExecuteNonQuery();
                MessageBox.Show("1");
                MessageBox.Show("更改后有: " + i2.ToString() + "行数据改变受到影响\n" + "删除后有:" + i2.ToString() + "行数据受到影响!\n");
                conn.Close();


            }catch(Exception ex)
            {
                MessageBox.Show(ex.Message.ToString() + "打开数据库失败!");
            
            }
        }
    }
}