VB怎么更新SQL里面某一列的数据为TEXT1里面的值??
Dim strSQL As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT SUT FROM ZERO_TAB", cnn
With rs
.Fields("SUT") = Text1.Text
.Update
End With
rs.Update
Dim strSQL As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT SUT FROM ZERO_TAB", cnn
With rs
.Fields("SUT") = Text1.Text
.Update
End With
rs.Update
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货