数控件MSHFlexGrid与ADO捆绑问题

[97xinben2]

datagrid与ADO捆绑时，ADO记录集改变时，datagrid表中的当前记录也相应改变，相反也一样。请问各位大吓，MSHFlexGrid与ADO捆绑能不能实现datagrid与ADO相同的功能？如何实现

[wynbfqny]

在MSFLEXGRID控件中每一个CELL格的内容是不可以由用户直接编辑的但是我们可以通过一些小技
巧来方便的实现这编辑功能来扩展MSFLEXGRID的应用（在实际应用中这是很常用的功能）。

你只需按下面的做即可轻松实现编辑MSFLEXGRID控件数据的功能

例在窗体上放一文本框text1，和一MSFLEXGRID控件flexgrid1
加入下例代码


Private Sub Form_Load()
Text1.Move -10000, -10000, 1, 1
End Sub

Private Sub MSFlexGrid1_EnterCell()
MSFlexGrid1.CellBackColor = vbBlue
MSFlexGrid1.CellForeColor = vbWhite
Text1.Text = MSFlexGrid1.Text
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End Sub

Private Sub MSFlexGrid1_LeaveCell()
MSFlexGrid1.CellBackColor = vbWhite
MSFlexGrid1.CellForeColor = vbBlue
End Sub

Private Sub MSFlexGrid1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
Text1.SetFocus
End Sub

Private Sub Text1_Change()
MSFlexGrid1.Text = Text1.Text
End Sub

Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyLeft, vbKeyRight, vbKeyUp, vbKeyDown
KeyCode = 0
End Select
End Sub


ok,这样一个可编辑的MSFLEXGRID控件就完成了，简单吧

注以上示为MSFLEXGRID控件，若用MSHFlexGrid请修改

[wamlaw]

不错！up

[lihonggen0]

工程--->引用--->Microsoft ActiveX Data Object 2.x（版本号）

Dim CN As New ADODB.Connection '定义数据库的连接
Dim Rs As New ADODB.Recordset

CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False"
CN.Open

Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic

Set MSHFlexGrid1.DataSource = Rs

[qpeg]

Private Sub Form_Load()
Text1.Move -10000, -10000, 1, 1
End Sub

Private Sub MSFlexGrid1_EnterCell()
MSFlexGrid1.CellBackColor = vbBlue
MSFlexGrid1.CellForeColor = vbWhite
Text1.Text = MSFlexGrid1.Text
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End Sub

Private Sub MSFlexGrid1_LeaveCell()
MSFlexGrid1.CellBackColor = vbWhite
MSFlexGrid1.CellForeColor = vbBlue
End Sub

Private Sub MSFlexGrid1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
Text1.SetFocus
End Sub

Private Sub Text1_Change()
MSFlexGrid1.Text = Text1.Text
End Sub

Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyLeft, vbKeyRight, vbKeyUp, vbKeyDown
KeyCode = 0
End Select
End Sub

[mihayi]

我想问一下wynbfqny(今无心)，这样一来，输入汉字的时候会不会出现问题？

因为，毕竟输入是在那个text中进行的

[sbfinger]

3楼的跟我做法相似。