dim rs as new adodb.recordset
set rs= A("SELECT * tbluser")
set datagrid.datasource=rs
call b("insert into tbluser(id) values('0009')"
這時想要datagrid中的數據更新﹐該如何
rs.update不行
set datagrid.datasource=rs也不行
當然重先取一次肯定是行的。不知有沒有更好的辦法
兩個含數﹐簡單表達如下
Public sub A (rsstring as string) as adodb.recordset
dim conn1 as new adodb.connection
conn1.Open IMS_CONNECTION_STRING '連接的數據源
conn1.CursorLocation = adUseClient
a=conn1.execute(rsstring)
end sub
public sub b(rsstring as string)
dim conn1 as new adodb.connection
conn1.Open IMS_CONNECTION_STRING
conn1.CursorLocation = adUseClient
conn
call conn1.execute(rsstring)
end sub