读书人

关于repeater控件绑定报错,该如何处理

发布时间: 2013-09-05 16:02:06 作者: rapoo

关于repeater控件绑定报错

后台
private void bind()
{
int TotalCount = 0;//总记录数
int TotalPage = 1; //总页数

SqlConnection conn = new SqlConnection(ConnStr);
//conn.Open();
//SqlDataAdapter da = new SqlDataAdapter("select ID,ModifiedTime,GradeLevel,CreateTime,DepartmentID,PositionID,B.UserID,SuggestSalary,RecuitingNum,RecuitingReasonType,Operation,T.G_CName as DepartmentName,T.GroupID,T1.GroupID,T1.G_CName as PositionName,C.UserID,C.U_CName from sys_AnwerbeformularDate as B INNER JOIN sys_Group AS T ON B.DepartmentID=T.GroupID INNER JOIN sys_Group AS T1 ON B.PositionID = T1.GroupID INNER JOIN sys_User AS C ON B.UserID=C.UserID ", conn);
//DataSet ds = new DataSet();

//da.Fill(ds, "sys_AnwerbeformularDate");
Zhaozh.FrameWork.Business.AnwerbeformularTableBll bind = new Zhaozh.FrameWork.Business.AnwerbeformularTableBll();

DataView dv = bind.getbind();
//DataView dv = ds.Tables[0].DefaultView;
TotalCount = dv.Count;
PDS.DataSource = dv;
conn.Close();
PDS.AllowPaging = true;
PDS.PageSize = 10;
int CurPage;
if (Request.QueryString["Page"] != null && Request.QueryString["Page"] != "0")
{


CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
PDS.CurrentPageIndex = CurPage - 1;
int Counts = PDS.PageCount;
labPage.Text = "共 " + Counts.ToString() + " 页";
if (!PDS.IsFirstPage && !PDS.IsLastPage)
{
first.Visible = true;
first.Enabled = true;
last.Visible = true;
last.Enabled = true;
next.Visible = true;
next.Enabled = true;
up.Visible = true;
up.Enabled = true;
this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Counts);
up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);


lb_Currentpage.Text = CurPage.ToString();
}
else if (!PDS.IsFirstPage && PDS.IsLastPage)
{
last.Visible = false;
last.Enabled = false;
up.Visible = true;
up.Enabled = true;
next.Visible = false;
next.Enabled = false;

this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
lb_Currentpage.Text = CurPage.ToString();
}
else if (PDS.IsFirstPage && !PDS.IsLastPage)
{
first.Visible = false;
first.Enabled = false;
next.Visible = true;
next.Enabled = true;
up.Visible = false;
up.Enabled = false;
this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Counts);


next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
lb_Currentpage.Text = CurPage.ToString();
}
else
{
first.Visible = false;
first.Enabled = false;
next.Visible = false;
next.Enabled = false;
up.Visible = false;
up.Enabled = false;
last.Visible = false;
last.Enabled = false;
}
Repeater1.DataSource = PDS;
Repeater1.DataBind();
}


dal层
public DataSet getbind()
{
SqlDataProvider sql = new SqlDataProvider();
string sqlSel = "select ID,ModifiedTime,GradeLevel,CreateTime,DepartmentID,PositionID,B.UserID,SuggestSalary,RecuitingNum,RecuitingReasonType,Operation,T.G_CName as DepartmentName,T.GroupID,T1.GroupID,T1.G_CName as PositionName,C.UserID,C.U_CName from sys_AnwerbeformularDate as B INNER JOIN sys_Group AS T ON B.DepartmentID=T.GroupID INNER JOIN sys_Group AS T1 ON B.PositionID = T1.GroupID INNER JOIN sys_User AS C ON B.UserID=C.UserID ";
SqlDataAdapter da = new SqlDataAdapter(sqlSel, GetSqlConnection());


DataSet ds = sql.reDs(sqlSel);
return ds;
}

bll层

public DataSet getbind()
{
SqlDataProvider da = new SqlDataProvider();
return da.getbind();
}

现在后台调用Bll层方法会报这个错,请问下该怎么解决

关于repeater控件绑定报错,该如何处理
[解决办法]
dataview dv=bind.getbind().Tables[0].DefaultView;
[解决办法]
bind.getbind()后面这样你点点能不能出来下面这样
bind.getbind().Tables[0].DefaultView
[解决办法]
错误好明显,类型都不一样。

读书人网 >asp.net

热点推荐