using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace AdoNetBase
{
/// <summary>
/// Summary description for ConnSqlServerDB
/// </summary>
public partial class ConnSqlServerDB : System.Web.UI.Page
{
// private String OracleConnectionString = "Provider=MSDAORA;UID=sa;PWD=dorient;Serve=dengjifu";
private String ConnectionString = "data source=DENGJIFU;Database=jwgl;uid=fu;pwd=5591960";
private String SQLConnectionString = "workstation id=ZHENGYD;integrated security=SSPI;data source=DENGJIFU;initial catalog=jwgl";
protected void Page_Load(object sender, System.EventArgs e)
{
///使用方法如下：程序默认状态下注销函数UserConnectionSQLServerDB()，
///此时为使用系统集成验证方式连接数据库
///如果想使用用户ID方法连接数据库，则注销函数InterConnectionSQLServerDB()，
///使函数UserConnectionSQLServerDB()有效即可
//InterConnectionSQLServerDB();
UserConnectionSQLServerDB();
}
private void UserConnectionSQLServerDB()
{
SqlConnection sqlConnection = new SqlConnection(ConnectionString);
try
{
sqlConnection.Open();
Response.Write("<script>alert('" + sqlConnection.ConnectionString.Replace(";","\\n") +"\\n数据库的连接成功！！！');</script>");
sqlConnection.Close();
}
catch(Exception ex)
{
Response.Write("数据库的连接失败！！！原因如下：<br>" + ex.Message);
}
}
private void InterConnectionSQLServerDB()
{
SqlConnection sqlConnection = new SqlConnection(SQLConnectionString);
try
{
sqlConnection.Open();
Response.Write("<script>alert('" + sqlConnection.ConnectionString.Replace(";","\\n") +"\\n数据库的连接成功！！！');</script>");
sqlConnection.Close();
}
catch(Exception ex)
{
Response.Write("数据库的连接失败！！！原因如下：<br>" + ex.Message);
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
}
#endregion
}
}
数据库的连接失败！！！原因如下：
在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: TCP 提供程序, error: 0 - 由于目标机器积极拒绝，无法连接。)
