マイクロソフトが自分で書いた~リモート・データベースが正常に動作しているかどうかをテストする

 1 <%@ Page Language="C#" %>

 2 

 3 <%@ Import Namespace="System.Data.SqlClient" %>

 4 <%        

 5     string ServerName = " ";

 6     string DBIP = "-"; //　-　 

 7     string DBName = "";

 8     string DBUser = "";

 9     string DBPassword = "";

10     string conn = string.Format(@"Data Source={0};Initial Catalog={1};Persist Security Info=True;

11                          User Instance=False;User ID={2};Password={3};MultipleActiveResultSets=true"

12        , DBIP

13        , DBName

14        , DBUser

15        , DBPassword);

16 

17 

18     string message = "NoSql";

19     if (DBIP != "-")

20     {

21         using (SqlConnection _conn = new SqlConnection(conn))

22         {

23             using (SqlCommand comm = new SqlCommand("SELECT COUNT(1)  FROM sys.tables", _conn))

24             {

25                 try

26                 {

27                     _conn.Open();

28                     comm.ExecuteReader();

29                     message = "OK";

30                     _conn.Close();

31                     _conn.Dispose();

32                 }

33                 catch (Exception)

34                 {

35                     message = "Fail";

36                 }

37 

38             }

39         }

40     }

41 

42 

43     string callback = Request["jsonpcallback"];

44     Response.ContentType = "application/x-javascript";

45     string str = callback + "({" + string.Format("\'ServerName\':\'{0}\', \'ServerIP\':\'{1}\',\'IISMessage\':\'{2}\',\'DBMessage\':\'{3}\'", ServerName, Request.ServerVariables["LOCAL_ADDR"].ToString(), "OK", message) + "})";

46     Response.Write(str);