1.检测电脑上安装有MS Sql数据库
string strConn = "Persist Security Info=False;Integrated Security=SSPI;database=master;server=(local);Connect Timeout=30"; System.Data.SqlClient.SqlConnection CheckConn =new System.Data.SqlClient.SqlConnection(strConn); CheckConn.Open(); 如果失败则没有安装,如果成功就表示有安装MS Sql数据库 2.检测安装有northwind、Master数据库实例 System.Data.SqlClient.SqlCommand sqlComm = new System.Data.SqlClient.SqlCommand("select name from sysdatabases",CheckConn); System.Data.SqlClient.SqlDataReader dr = sqlComm.ExecuteReader(); while( dr.Read() ) { if (dr.GetValue(0).ToString().ToLower() == "northwind") { strSign = "1"; break; } } dr.Close(); 如果strSign 为0则表示没有northwind,为1则表示有northwind |
|