datagrid错误,我已经头大了
我以下的程序:
1个form,1个cmd(删除),1个datagrid
--
public cnn as new adodb.connection
public rs as new adodb.recordset
--
private sub form_load()
cnn.Open "driver={sybase system};srvr=192.168.9.1,uid=sa,pwd=sa;database=aa"
rs.Open "select * from table_name", cnn, 3, 3
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
end
--
Private Sub Command3_Click()
DataGrid1.AllowDelete = True
rs.Delete '这里报错
rs.Update
End Sub
错误信息:
Err.Number:-2147467259
Err.Source :Microsoft Cursor Engine
Err.Description :数据提供程序或其他服务返回E_FAIL状态。
另:谁能提供有关datagrid的修改,增加,删除的代码,小弟不胜感激!