using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ConnectionObject rs=new ConnectionObject();
}
}public class ConnectionObject
{ public ConnectionObject()
{ string connstring= ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString();
string sqlstring="select * from ua";
SqlConnection conn=new SqlConnection(connstring);
SqlCommand rs=new SqlCommand(sqlstring,conn);
conn.Open();
}
}
Web.config->
<add key="SQLCONNECTIONSTRING" value="server=(local);uid=sa;pwd=hgxbralogin;data source=ht"/>错误:在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。我用的sql2000,直接用 工具->连接数据库, 可以连上求更正错误
server=localhost;
database=ht;
integrated security=sspi;";
你这就是个本地连接吧.
<add key="SQLCONNECTIONSTRING" value="server=(local);uid=sa;pwd=hgxbralogin;database=ht"/>