asp .net连接打开数据库初步

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

WebDriver
posted @ 2014-11-25 17:38  zzg168  阅读(99)  评论(0编辑  收藏  举报