为什么datagrid不能修改数据?
我已把datagrid1AllowArrows,AllowDelete,AllowUpdate的属性设为true
Private Sub Form_Load()'建立连接
Set cnn1 = New ADODB.Connection
Set com1 = New ADODB.Command
Set rec1 = New ADODB.Recordset
cnn1.ConnectionString = "driver={sql server};server=gtd;uid=sa;pwd=;database=CLASS"
cnn1.Open
Set com1.ActiveConnection = cnn1
End Sub
'按下按钮时列出数据
Private Sub cmdList_Click()
com1.CommandText = "select * from zm"
rec1.Open com1, , adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = rec1
End Sub
为什么直接点表格里的数据无法修改?就象是readonly一样