非常郁闷的问题,MSHFlexGrid求救
我是用combo来调用数据库,在MSHFlexGrid上显示数据库内容的。
代码如下:
Private Sub combo_Click()
Dim mrc As ADODB.Recordset
Dim SQL As String
SQL = "select * from user where ID ='" & Trim(combo.Text) & "'"
Set mrc = ExecuteSQL(SQL)
Set MSHFlexGrid.DataSource = mrc
mrc.Close
End Sub
Private Sub MSHFlexGrid_Click()
With MSHFlexGrid
.Col = 0
A.Text = .Text
.Col = 1
B.Text = .Text
End With
End Sub
MSHFlexGrid能正常显示数据,但就不知道为什么我点击MSHFlexGrid里的各项数据却永远只能选择第一行的,二三等行的就不能选择了。请问有办法解决吗?我发觉要是把"select * from user where ID ='" & Trim(combo.Text) & "'"的" & Trim(combo.Text) & "换成具体的数据就能解决,但这就没意义啦,请帮帮忙!!!