连接数据库页面部分DB.cs:
using System;
using System.Data;
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;
using System.Data.SqlClient;
/// <summary>
/// DB 的摘要说明
/// </summary>
/// public class DB
{
public static SqlConnection creatconnection()
{
SqlConnection con = new SqlConnection("server=LXH;database=lxh;uid=luo;pwd=111111");
return con;
}
}主代码页面部分vote.aspx.cs
using System;
using System.Data;
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;
using System.Data.SqlClient; public partial class vote : System.Web.UI.Page
{
private int voteID = 1; //工会1
protected void Page_Load(object sender,EventArgs e)
{
SqlConnection con = DB.creatconnection();
con.Open(); <<----------//就这出现问题了
SqlCommand cmd = new SqlCommand("select voteTitle from [vote] where voteID" + this.voteID, con);
string title = Convert.ToString(cmd.ExecuteReader());
this.lbltitle.Text = title;
}
}错误提示: 连接代码部分哪错了呢?在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL
using System;
using System.Data;
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;
using System.Data.SqlClient;
/// <summary>
/// DB 的摘要说明
/// </summary>
/// public class DB
{
public static SqlConnection creatconnection()
{
SqlConnection con = new SqlConnection("server=LXH;database=lxh;uid=luo;pwd=111111");
return con;
}
}主代码页面部分vote.aspx.cs
using System;
using System.Data;
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;
using System.Data.SqlClient; public partial class vote : System.Web.UI.Page
{
private int voteID = 1; //工会1
protected void Page_Load(object sender,EventArgs e)
{
SqlConnection con = DB.creatconnection();
con.Open(); <<----------//就这出现问题了
SqlCommand cmd = new SqlCommand("select voteTitle from [vote] where voteID" + this.voteID, con);
string title = Convert.ToString(cmd.ExecuteReader());
this.lbltitle.Text = title;
}
}错误提示: 连接代码部分哪错了呢?在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL
Sqlconnection con = new SqlConnection("server = (local);database = pubs;uid = sa;pwd = sa"); //括号里是连接字符串 数据库名字自己改
con.Open();
SqlCommand cmd = new Sqlcommand("select voteTitle from [vote] where voteID =" + this.voteID.Tostring(),con);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
this.lbltitle.Text = sdr.GetValue(0).ToString(); //括号里是列的索引 0表示是第一列
}
sdr.close();
con.close();
{
SqlConnection con = new SqlConnection("server=LXH;database=lxh;uid=luo;pwd=111111");
return con;
}con.open 异常一般都是连接字符串出问题了,要不就是数据库的问题,你先把服务器改成本机试下看!
还要检查一下你的数据库是否已经建好了对你要连接的数据库的一个远程连接。