access库如何使用ObjectDataSource分页 ？？
我学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);没有初始化的错误提示信息??
但不对啊？？？？？？？？
[解决办法]
access和ObjectDataSource有什么关系，好像ObjectDataSource是绑定对象的吧，不是数据库
[解决办法]
If Request.QueryString( "Btid ") Is Nothing Or Request.QueryString( "Btid ") = " " Then
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
[解决办法]
Public Function CreatDataSource(ByVal Tid As String) As DataTable
Return Prd.GetProductInfoByBigType(Tid)
End Function
------------------------------------------------
以前用VB。NET写的，不知道对你有没帮助
[解决办法]
没用过这东西.不过这东西是个数据源控件.跟access有什么关系?
帮顶一下
