在DAL层写的是通过信息类型的TypeID值查询前五条信息
public void SelectByType(string TypeID,string New,string NewTitle)
{
string Connstring = ConfigurationManager.ConnectionStrings[0].ToString();
using (SqlConnection conm = new SqlConnection(Connstring))
{
SqlCommand cmd = conm.CreateCommand();
cmd.CommandText = "Select top 5 NewTitle,New from News where TypeID=@TypeID";
cmd.Parameters.Add(new SqlParameter("@TypeID", TypeID));
cmd.Parameters.Add(new SqlParameter("@New", New));
cmd.Parameters.Add(new SqlParameter("@NewTitle", NewTitle));
conm.Open();
cmd.ExecuteNonQuery();
}在BLL层写的是:
public void SelectByType(string TypeID, string New, string NewTitle)
{
DAL.NewsDAO dao = new DAL.NewsDAO();
dao.SelectByType(TypeID, New, NewTitle);
}
在.aspx.cs文件中写的是:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetBind();
}
} public void SetBind()
{
yujia.BLL.NewsManager nm = new yujia.BLL.NewsManager(); Repeater1.DataSource = nm.SelectByType();
Repeater1.DataBind();
}错误提示是 : SelectByType()方法没有任何冲在采用“0”个参数,谁知道是为什么啊能顺便给我说一下在在.ASPX页面上怎么样写有关Repeater的调用参数嘛
public void SelectByType(string TypeID,string New,string NewTitle)
{
string Connstring = ConfigurationManager.ConnectionStrings[0].ToString();
using (SqlConnection conm = new SqlConnection(Connstring))
{
SqlCommand cmd = conm.CreateCommand();
cmd.CommandText = "Select top 5 NewTitle,New from News where TypeID=@TypeID";
cmd.Parameters.Add(new SqlParameter("@TypeID", TypeID));
cmd.Parameters.Add(new SqlParameter("@New", New));
cmd.Parameters.Add(new SqlParameter("@NewTitle", NewTitle));
conm.Open();
cmd.ExecuteNonQuery();
}在BLL层写的是:
public void SelectByType(string TypeID, string New, string NewTitle)
{
DAL.NewsDAO dao = new DAL.NewsDAO();
dao.SelectByType(TypeID, New, NewTitle);
}
在.aspx.cs文件中写的是:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetBind();
}
} public void SetBind()
{
yujia.BLL.NewsManager nm = new yujia.BLL.NewsManager(); Repeater1.DataSource = nm.SelectByType();
Repeater1.DataBind();
}错误提示是 : SelectByType()方法没有任何冲在采用“0”个参数,谁知道是为什么啊能顺便给我说一下在在.ASPX页面上怎么样写有关Repeater的调用参数嘛
Repeater1.DataBind()
没传参数.