net c# 代码连接数据库

net c# 代码连接数据库
为了测试是否连接数据库，采用下面的代码。
private void dd()
{
SqlConnection _SqlConnection = new SqlConnection();
try
{
string strConn = “Server=192.168.1.120;Database=test;UID=sa;PWD=111111;Enlist=true;Pooling=true;Max Pool Size=512;Min Pool Size=0;Connection Lifetime=2000;packet size=2000”;

            string sql = "select * from test1";

            _SqlConnection.ConnectionString = strConn;

            _SqlConnection.Open();
            SqlCommand com = new SqlCommand(sql, _SqlConnection);
            com.CommandTimeout = 180;
            SqlDataAdapter sda = new SqlDataAdapter(com);
            sda.SelectCommand.CommandTimeout = 180;
            DataSet ds = new DataSet();
            sda.Fill(ds);
        }
        catch (Exception e)
        {
            _SqlConnection.Close();
        }
        finally
        {
            _SqlConnection.Close();
        }
    }
    
private void dd()
{
    SqlConnection conn = new SqlConnection("server='192.168.1.11';user id=sa;password=111111;database=test");
    conn.Open();

    SqlCommand cmd = new SqlCommand("select * from test2", conn);

    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    da.Fill(ds);

    conn.Close();
}