VB怎么更新SQL里面某一列的数据为TEXT1里面的值
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