我学access数据,初学ObjectDataSource分页!!startrowindexparamert和maxmunrowsparamert参数设置如下
public static OleDbDataReader GetUser(int rowIndex, int recordCount)
{
conn = ControlData.Connstring();
string selectString = "select Uid,Name,Password,Rname,RoleId from [User] inner join [Role] on Role.Rid=User.RoleId";
cmd = new OleDbCommand(selectString, conn);
conn.Open();
DataReader = cmd.ExecuteReader();
return DataReader;
DataReader.Close();
DataReader.Dispose();
}
!!但不知在类方法如何加入上面参数??试过改为
public static OleDbDataReader GetUser(int rowIndex, int recordCount)
{
//===================================================
//conn = ControlData.Connstring();
//string selectString = "select top @recordCount * from [User] inner join [Role] on Role.Rid=User.RoleId where Uid not in (select top (@rowIndex*recordCount) Uid from [User] order by id desc) order by id desc"; //OleDbParameter spRowIndex = new OleDbParameter("@rowIndex",OleDbType.Integer, 4);
//spRowIndex.Direction = ParameterDirection.Input;
//OleDbParameter spRecordCount = new OleDbParameter("@recordCount", OleDbType.Integer, 4);
//spRecordCount.Direction = ParameterDirection.Input; //spRowIndex.Value = rowIndex;
//spRecordCount.Value = recordCount; //cmd.Parameters.Add(spRowIndex);
//cmd.Parameters.Add(spRecordCount);
//cmd = new OleDbCommand(selectString, conn);
//conn.Open();
//DataReader = cmd.ExecuteReader();
//return DataReader;
//DataReader.Close();
//DataReader.Dispose();
}
//cmd.Parameters.Add(spRowIndex);
//cmd.Parameters.Add(spRecordCount);没有初始化的错误提示信息??
但不对啊????????
public static OleDbDataReader GetUser(int rowIndex, int recordCount)
{
conn = ControlData.Connstring();
string selectString = "select Uid,Name,Password,Rname,RoleId from [User] inner join [Role] on Role.Rid=User.RoleId";
cmd = new OleDbCommand(selectString, conn);
conn.Open();
DataReader = cmd.ExecuteReader();
return DataReader;
DataReader.Close();
DataReader.Dispose();
}
!!但不知在类方法如何加入上面参数??试过改为
public static OleDbDataReader GetUser(int rowIndex, int recordCount)
{
//===================================================
//conn = ControlData.Connstring();
//string selectString = "select top @recordCount * from [User] inner join [Role] on Role.Rid=User.RoleId where Uid not in (select top (@rowIndex*recordCount) Uid from [User] order by id desc) order by id desc"; //OleDbParameter spRowIndex = new OleDbParameter("@rowIndex",OleDbType.Integer, 4);
//spRowIndex.Direction = ParameterDirection.Input;
//OleDbParameter spRecordCount = new OleDbParameter("@recordCount", OleDbType.Integer, 4);
//spRecordCount.Direction = ParameterDirection.Input; //spRowIndex.Value = rowIndex;
//spRecordCount.Value = recordCount; //cmd.Parameters.Add(spRowIndex);
//cmd.Parameters.Add(spRecordCount);
//cmd = new OleDbCommand(selectString, conn);
//conn.Open();
//DataReader = cmd.ExecuteReader();
//return DataReader;
//DataReader.Close();
//DataReader.Dispose();
}
//cmd.Parameters.Add(spRowIndex);
//cmd.Parameters.Add(spRecordCount);没有初始化的错误提示信息??
但不对啊????????
解决方案 »
- 急!在线等,有答案立刻结贴。
- 如何在用户注册时给用户生成一个个性化域名,就象点点网那样?
- 两个listbox之间传数据传递
- .net实现鼠标右键列出菜单
- 100分,写帐户登陆类时遇到密封的问题!在线急求高人解!
- 因为有人推荐,所以看了一下 freeTextbox 网站。发现需要好几千块?有真正免费(free)的吗?
- 救命问题:要交毕业设计了,还有一个重要问题没解决,高手过来帮帮忙,help!~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- 网站连接不上怎么回事?
- (新手)ASP网页问题
- 请whn801213 (新被子) 和chieftech进来解释一下怎么回事
- 不知道这个算不算难点? 高手是不在乎一些分的
- .net反编译工具
Response.Write("<script>alert('页面参数出错!');location.href='../default.aspx'></script>")
Else
Tid = Int(Request.QueryString("Btid").ToString) Dim Pgds As PagedDataSource = New PagedDataSource
Pgds.DataSource = CreatDataSource(Tid).DefaultView
Pgds.AllowPaging = True
Pgds.PageSize = 5
lblTotalPage.Text = Pgds.PageCount.ToString()
Dim CurrentPage As Integer
If Not Request.QueryString("Page") Is Nothing Then
CurrentPage = Convert.ToInt32(Request.QueryString("Page"))
Else
CurrentPage = 1
End If Pgds.CurrentPageIndex = CurrentPage - 1
lblCurrentPage.Text = CurrentPage.ToString() If Not Pgds.IsFirstPage Then
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurrentPage - 1) + "&Btid=" + Tid.ToString
Else
Me.lnkPrev.Enabled = False
End If If Not Pgds.IsLastPage Then
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurrentPage + 1) + "&Btid=" + Tid.ToString
Else
Me.lnkNext.Enabled = False
End If rep_prdt.DataSource = Pgds
rep_prdt.DataBind() End If
Return Prd.GetProductInfoByBigType(Tid)
End Function
------------------------------------------------
以前用VB。NET写的,不知道对你有没帮助