请问vb程序中的datagrid控件如何使用？

来源：百度知道 编辑：UC知道 时间：2024/06/06 14:35:10
请问如何在datagrid控件中实现类似与excel的功能，例如增加删除行、添加编辑、和调用等功能，请最好举例说明！

只要绑定了数据不就可以了阿。我有个程序。你拿去看看吧。一个FORM一个datagrid控件就OK了
Public Function InitDataRecordset(ByVal sqlText As String) As ADODB.Recordset

Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset
Dim sql As String
cnn.ConnectionString = "Provider = SQLOLEDB.1;Persist Security Info = False;" & _
"User ID = sa;Password = ;Data Source =YNTDEV252;" & _
"Initial Catalog = shiyan"
cnn.ConnectionString = strConnection
cnn.Open
rst.CursorLocation = adUseClient
rst.Open sqlText, cnn, adOpenDynamic, adLockOptimistic

Set InitDataRecordset = rst
'MsgBox rst.RecordCount

End Function

Private Sub Form_Load()
Dim kk As New ADODB.Recordset
Set