1。 ssql = "select * from table where id='22'"
rs.Open ssql, data, adOpenDynamic, adLockOptimistic
For i = 0 To rs.Fields.Count - 1
MSHFlexGrid1.Col= i
MSHFlexGrid1.Text = rs(i)
Next
2. ssql="select * from table where id<>'22'"
rs.open ssql,data,adopendynamic,adlockoptimistic
for i =0 to rs.recordcount-1
for j= 0 to rs.fields.count -1
mshflexgrid1.text = rs(i)
next
next
上面那个错了~~~
查询按钮代码大致如下:
Private Sub Command1_Click()
MSFlexGrid1.Col = 0
MSFlexGrid1.Row = 0
MSFlexGrid1.ColSel = MSFlexGrid1.Cols - 1
MSFlexGrid1.RowSel = MSFlexGrid1.Rows - 1
MSFlexGrid1.CellFontBold = False
MSFlexGrid1.FillStyle = flexFillSingle
For j = 0 To MSFlexGrid1.Cols - 1
For i = 0 To MSFlexGrid1.Cols - 1
If InStr(MSFlexGrid1.TextMatrix(i, j),Text1.Text) Then
MSFlexGrid1.Col = j
MSFlexGrid1.Row = i
'第I行的记录就是我想要的记录如果把他显示到第一行来啊?或者是把这一条记录
'输出到一个文件也行!
End If
Next i
Next j
End Sub
查询按钮代码大致如下:
Private Sub Command1_Click()
MSFlexGrid1.FillStyle = flexFillRepeat
MSFlexGrid1.Col = 0
MSFlexGrid1.Row = 0
MSFlexGrid1.ColSel = MSFlexGrid1.Cols - 1
MSFlexGrid1.RowSel = MSFlexGrid1.Rows - 1
MSFlexGrid1.CellFontBold = False
MSFlexGrid1.FillStyle = flexFillSingle
For j = 0 To MSFlexGrid1.Cols - 1
For i = 0 To MSFlexGrid3.Cols - 1
If (MSFlexGrid1.TextMatrix(i, j) = Text1.Text) Then
MSFlexGrid1.Col = j
MSFlexGrid1.Row = i
'第I行的记录就是我想要的记录如果把他显示到第一行来啊?或者是把这一条记录
'输出到一个文件也行!
End If
Next i
Next j
End Sub