To dbcontrols(aa): 比如: strsql = "select games.gameid,hostname,visitingname,gue3,gue1,gue0,guessmanName from games INNER JOIN (guessman INNER JOIN guesstb ON guessman.guessmanID = guesstb.guessmanID) ON games.matchid = guesstb.matchid and games.gameid=guesstb.gameid where guessman.guessmanid=" & guessmancmb.BoundText & " and games.matchid=" & lcnamecmb.BoundTextSet tablers = New ADODB.Recordset tablers.Open strsql, cn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = tablers一旦修改数据,VB报错:“多步OLE DB操作产生错误。”
难道,DATAGRID就不支持连接查询的数据更新!!!
Adodc1.RecordSource = "select * from santong where 编号='" & SanTongBH & "'" Adodc1.Refresh DataGrid1.ReBind Set DataGrid1.DataSource = Adodc1
更新是在DATAGRID中显示的数据进行直接修改
比如:
strsql = "select games.gameid,hostname,visitingname,gue3,gue1,gue0,guessmanName from games INNER JOIN (guessman INNER JOIN guesstb ON guessman.guessmanID = guesstb.guessmanID) ON games.matchid = guesstb.matchid and games.gameid=guesstb.gameid where guessman.guessmanid=" & guessmancmb.BoundText & " and games.matchid=" & lcnamecmb.BoundTextSet tablers = New ADODB.Recordset
tablers.Open strsql, cn, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = tablers一旦修改数据,VB报错:“多步OLE DB操作产生错误。”
Adodc1.Refresh
DataGrid1.ReBind
Set DataGrid1.DataSource = Adodc1