數據更新問題﹐在線等待
dim csConnection As ADODB.connection
dim rs as adodb.recordsetSet csConnection = New ADODB.connectioncsConnection.Open IMS_CONNECTION_STRING '后為邊接的數據源
csConnection.CursorLocation = adUseClient
set rs = adodb.recordset
set rs=csConnection.Execute(query) 'query為select語句
set datagrid.datasource=rs
csConnection.Execute query2 'query為insert語句
執行后為何datagrid里面的數據不能更新
dim csConnection As ADODB.connection
dim rs as adodb.recordsetSet csConnection = New ADODB.connectioncsConnection.Open IMS_CONNECTION_STRING '后為邊接的數據源
csConnection.CursorLocation = adUseClient
set rs = adodb.recordset
set rs=csConnection.Execute(query) 'query為select語句
set datagrid.datasource=rs
csConnection.Execute query2 'query為insert語句
執行后為何datagrid里面的數據不能更新
set datagrid.datasource=rs
看看
csConnection.Execute query2 'query為insert語句
'再帮定一次
set datagrid.datasource=rs
改成set rs = new adodb.recordset
rs.CursorType = adOpenDynamic
rs.LockType = adLockPessimistic
set rs= 函數返加記錄集
set datagrid.datasource=rs