1.用Ddodc和DataGrid怎样配合实现分页?
2.这两个控件必须一起使用吗?
3.在不同的form中,是否要重复定义Adodc和Datagrid
*********** **********
还是急,我要急饿了!!!
2.这两个控件必须一起使用吗?
3.在不同的form中,是否要重复定义Adodc和Datagrid
*********** **********
还是急,我要急饿了!!!
解决方案 »
- 请问引用时间变量时该用什么符号?、
- 有关数据备份的问题
- 奇怪呀!为什么我的程序不能运行两个 adocm.execute?
- 怎样关闭vb程序外父窗口的子窗口?
- 请问一下,我用datagrid控件,我想定义columns的caption,可是属性里的columns属性里为什么只有两个(columns1,column2),怎么再添加其
- 谁有XP风格的TOOLBAR控件啊,有的请进~!急~!
- 图片的读取(Access),得到答案就结贴,不够再加分
- 一个奇怪的关于activex控件的问题……
- hcat1999([email protected]); 你是斑竹吗?我好冤啊
- 这里有VB高手吗?
- 水晶报表8.5那个要!!
- 菜鸟求救:包含控件的问题
2.不一定
3.不用重复定义
举个就结分,我要源代码!
简单点就行了!
On Error Resume NextAdodc1.Recordset.AbsolutePage = Adodc1.Recordset.AbsolutePage - 1
cur_Page = Adodc1.Recordset.AbsolutePageMSFlexGrid1.Clear
MSFlexGrid1.Rows = myPageSize + 1
MSFlexGrid1.Cols = Adodc1.Recordset.Fields.Count
For i = 0 To Adodc1.Recordset.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, i) = Adodc1.Recordset.Fields(i).Name
NextFor j = 1 To myPageSize
For i = 0 To Adodc1.Recordset.Fields.Count - 1
MSFlexGrid1.TextMatrix(j, i) = Adodc1.Recordset.Fields(i).Value
Adodc1.Recordset.MoveNext
Next
Next
Adodc1.Recordset.AbsolutePage = cur_PageEnd SubPrivate Sub Command2_Click()
On Error Resume NextAdodc1.Recordset.AbsolutePage = Adodc1.Recordset.AbsolutePage + 1
cur_Page = Adodc1.Recordset.AbsolutePageMSFlexGrid1.Clear
MSFlexGrid1.Rows = myPageSize + 1
MSFlexGrid1.Cols = Adodc1.Recordset.Fields.CountFor i = 0 To Adodc1.Recordset.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, i) = Adodc1.Recordset.Fields(i).Name
NextFor j = 1 To myPageSize
For i = 0 To Adodc1.Recordset.Fields.Count - 1
MSFlexGrid1.TextMatrix(j, i) = Adodc1.Recordset.Fields(i).Value
Adodc1.Recordset.MoveNext
Next
NextAdodc1.Recordset.AbsolutePage = cur_Page
End SubPrivate Sub Form_Load()
On Error Resume Next
myPageSize = 4cur_Page = 1Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from test"
Adodc1.Refresh
Adodc1.Recordset.PageSize = myPageSizeMSFlexGrid1.Rows = myPageSize + 1
MSFlexGrid1.Cols = Adodc1.Recordset.Fields.CountFor i = 0 To Adodc1.Recordset.Fields.Count - 1
MSFlexGrid1.TextMatrix(0, i) = Adodc1.Recordset.Fields(i).Name
NextFor j = 1 To myPageSize
For i = 0 To Adodc1.Recordset.Fields.Count - 1
MSFlexGrid1.TextMatrix(j, i) = Adodc1.Recordset.Fields(i).Value
Adodc1.Recordset.MoveNext
Next
NextAdodc1.Recordset.AbsolutePage = cur_PageEnd Sub