asp.net按钮刷新功能失败原因

Question

刷新按钮点击失败原因：Unknown column '__Page' in 'where clause'

从源码上看没有__page ，怎么去修改？？？

源码附上：
UI (cs文件）
protected void ref_Click(object sender, EventArgs e)
{
DataTable table2 = BLL.ChangeOverMgr.SearchMaterials1(ID);
this.Materials.DataSource = table2;
this.Materials.DataBind();
ViewState["table"] = table2;
}

DAL（数据处理文件）
public DataTable SearchMaterials1(string ID)
{
string cmdText = @"select a.pn,a.station,a.materialsid,c.status1 from materials a
left join changeoverhis b on a.pn=b.pn
left join exa_materials c on a.materialsid=c.materialsid and b.id = c.hisid where 1=1";
cmdText = cmdText + " and b.id =" + ID + "";
cmdText = cmdText + " order by status1 desc,station;";
return MysqlHelper.ExecuteDataTable(cmdText);
}

Answer 1

你的ID参数从哪搞来的？没有其他地方赋值那就默认调用Page.ID这个属性了，默认就是__Page内容，所有构造的sql语句报错了，自己搞清楚ID是什么东西，重新获取