1 //测试连接字符串是否成功
2 #region
3 using System;
4 using System.Collections.Generic;
5 using System.Linq;
6 using System.Web;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Data.SqlClient;
10 using System.Configuration;
11
12 public partial class test_Default : System.Web.UI.Page
13 {
14 protected void Page_Load(object sender, EventArgs e)
15 {
16 string str = ConfigurationManager.ConnectionStrings["haqiuConnectionString"].ConnectionString;
17 SqlConnection strConn = new SqlConnection(str);
18 if (strConn == null)
19 {
20 Response.Write("连接字符串为空！");
21 }
22 else
23 {
24 Response.Write("连接字符串不为空！");
25 }
26 }
27 }
28 #endregion
29
30 //打开数据库连接
31 #region
32 using System;
33 using System.Collections.Generic;
34 using System.Linq;
35 using System.Web;
36 using System.Web.UI;
37 using System.Web.UI.WebControls;
38 using System.Data.SqlClient;
39 using System.Configuration;
40
41 public partial class test_Default : System.Web.UI.Page
42 {
43 protected void Page_Load(object sender, EventArgs e)
44 {
45 string str = ConfigurationManager.ConnectionStrings["haqiuConnectionString"].ConnectionString;
46 SqlConnection strConn = new SqlConnection(str);
47 if (strConn.State.ToString()=="Closed")
48 {
49 strConn.Open();
50 Response.Write("数据库连接已经打开！");
51 }
52 else
53 {
54 Response.Write("数据库连接无法打开！");
55 }
56 }
57 }
58 #endregion
59
代码
