A标签绑定的ID找不到
这是SQL语句select * from ST_Project_BasicInfo as u,ST_TechComment_SumView as s where u.Project_Id=s.ProjectId and u.DepartmentId=1 and u.State>=20 and u.Project_Sort in (1,2,3) order by u.Project_CommentId desc, u.Project_Sort desc
页面报错 里面绑定的Project_Id找不到 请大神赐教啊
<a href="../Project/ST_Project_Detail.aspx?id=<%#DataBinder.Eval(Container.DataItem,"Project_Id")%>"> --------------------编程问答-------------------- select * from ST_Project_BasicInfo as u,ST_TechComment_SumView as s where u.Project_Id=s.ProjectId and u.DepartmentId=1 and u.State>=20 and u.Project_Sort in (1,2,3) order by u.Project_CommentId desc, u.Project_Sort desc
你这里面的这个*该为你要查询的列名
u.Project_Id=s.ProjectId 这样的话
Project_Id不明确的 --------------------编程问答--------------------
+1
select * 改为select u.project_id,u.project_commentid.....这样的 --------------------编程问答-------------------- select * 改为select project_id=u.project_id,u.project_commentid.....这样的
绝对是正确的哥们 --------------------编程问答-------------------- 你把你的SQL 放查询分析器里跑
看查出的结果有没有Project_Id这个列。 --------------------编程问答-------------------- 我知道,但是from前面的都看不见
private string GetHql()
{
System.Text.StringBuilder builder = new System.Text.StringBuilder();
//工作人员列表
builder.Append(" from ST_Project_BasicInfo as u where 1=1 ");
if (user.ChartView.StId != 20 && user.ChartView.StId != 0)
builder.Append(" and u.RelationShentu.StId=" + user.ChartView.StId);
//项目工作流
builder.Append(" and u.RelationProjectWorkFlow.Node_id>= 20 ");
builder.Append(" and u.RelationProjectSort.Project_Sort_Id in (1,2,3)");
if (txtProjectName.Text.Trim() != "")
builder.Append(" and u.Project_Name like '%" + txtProjectName.Text.Trim() + "%'");
if (Project_CommentId.Text.Trim() != "")
{
builder.Append(" and u.Project_CommentId like '%" + Project_CommentId.Text.Trim() + "%'");
}
builder.Append(" order by u.Project_CommentId desc, u.RelationProjectWorkFlow.Node_id desc");
return builder.ToString();
} --------------------编程问答-------------------- 看不见也可以测试啊。如果你返回的是DataSet等,你可以查看DataTable的每列的列名看是否有Project_Id这个字段名称啊
DataTable item = ds.Tables[0];
foreach (DataColumn col in item.Columns)
Response.Write( col.ColumnName);
补充:.NET技术 , ASP.NET