新手--关于制作数据库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 db()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection createConnection()
{
SqlConnection con =new SqlConnection("server=; database=vote;uid=sa;pwd=;");
return con;
}
}
我看的是北大青鸟的视频教程,按照他的做法我先做了一个DB.CS的连接类。他用的是2003,我的是VS2005,我把该类放到了方案的APP_Code下,但运行一下还是提示错误:无法将方法组“createConnection”转换为非委托类型“System.Data.SqlClient.SqlConnection”。您是要调用方法吗? 请高手指教啊
下面的主程序是:
ing 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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//
SqlConnection con = db.createConnection;--------------系统就提示这个东西有问题
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
private string voteID = "1";
protected void btnitems_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = db.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("select votetitle from voteMaster where voteId=" + this.voteID, con);
string title = Convert.ToString(cmd.ExecuteScalar());
this.labtitle.Text = Title;
//查询选举条目
SqlCommand cmdItem = new SqlCommand("select id,voteitem from voteDetails where voteid=" + this.voteID, con);
SqlDataReader sdr = cmdItem.ExecuteReader();
this.btnitems.DataSource = sdr;
this.btnitems.DataTextField = "aaaaa";
this.btnitems.DataValueField = "voteid";
this.btnitems.DataBind();
sdr.Close();
con.Close();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}