ASP.NET程序中的web.config中的连接字符串为：
ASP.NET程序与sql server 2005数据库连接不单是需要在配置文件中配置好数据库名、用户名、密码、IP地址。还需要在程序中也要写好与数据库的连接方法，然后在web.config中来调用才能正常连接，这样程序在使用过程中才不会报与数据库连接错误。
1、ASP.NET程序与sql server 2005数据库连接方法代码：（注：与数据库连接的方法有很多，但是都是大同小异）
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data.Sql;
namespace DLL
{
public class DBHelper
{
public static string conn = ConfigurationManager.ConnectionStrings["Conn"].ToString();
//public static string conn =ConfigurationManager.AppSettings["SqlConnString"].ToString();
static SqlConnection con = null;
///
/// 判断数据库连接状态
///
///
public static SqlConnection getConnection()
{
try
{
if (con == null)
{
con = new SqlConnection(conn);
}
if (con.State == ConnectionState.Broken)
{
con.Close();
con.Open();
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
}
catch (Exception ex)
{
throw ex;
}
return con;
}
public static SqlCommand NewMethod(string sql, SqlParameter[] par)
{
SqlCommand com = new SqlCommand(sql, getConnection());
if (par != null)
{
foreach (SqlParameter parameter in par)
{
if (parameter.Value == null)
{
parameter.Value = DBNull.Value;
}
com.Parameters.Add(parameter);
}
}
return com;
}
public static DataSet Dataset(string sql, SqlParameter[] par, string tableName)
{
DataSet set = new DataSet();
SqlCommand comm = NewMethod(sql,par);
if(tableName==null || tableName=="")
{
tableName = "tableName";
}
SqlDataAdapter dapter = new SqlDataAdapter(sql, getConnection());
dapter.Fill(set,tableName);
return set;
}
public static DataTable Table(string sql, SqlParameter[] par, string tableName)
{
DataTable table = new DataTable();
try
{
table = Dataset(sql, par, tableName).Tables[0];
return table;
}
catch (Exception ex)
{
throw ex;
}
}
public static SqlDataReader Reader(string sql,SqlParameter[] par)
{
SqlDataReader red = null;
SqlCommand comm = NewMethod(sql,par);
try
{
red = comm.ExecuteReader();
}
catch (Exception ex)
{
red.Close();
con.Close();
throw ex;
}
return red;
}
public static int Execut(string sql, SqlParameter[] par)
{
int num = 0;
SqlCommand com = NewMethod(sql, par);
try
{
num = com.ExecuteNonQuery();
}
catch (Exception ex)
{
num = 0;
}
con.Close();
return num;
}
}
}
2、web.config配置文件的连接代码为：
