你好,我的adshq表有2个字段 zhangh,kehhao
我用了一个DATA GIRD 显示这个表的数据,我希望就是每次不用输入zhangh
让它每次自动加1,我写了下面的程序,但是运行没什么效果。帮点忙好吗?
Option Explicit
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim perid As String
Private Sub Command1_Click()
Dim newid As Integer
Adodc1.Recordset.AddNew
newid = Val(Trim(perid)) + 1
rs!zhangh = Str(newid)
End Sub
我用了一个DATA GIRD 显示这个表的数据,我希望就是每次不用输入zhangh
让它每次自动加1,我写了下面的程序,但是运行没什么效果。帮点忙好吗?
Option Explicit
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim perid As String
Private Sub Command1_Click()
Dim newid As Integer
Adodc1.Recordset.AddNew
newid = Val(Trim(perid)) + 1
rs!zhangh = Str(newid)
End Sub
"select max(hangh) from adshq"
Option Explicit
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim perid As StringPrivate Sub Command1_Click()
Dim newid As Integer
Dim strSQL As String
If rs Is Nothing Then
Set rs = New ADODB.Recordset
ElseIf rs.State = adStateOpen Then
rs.Close
End If
Adodc1.Recordset.AddNew
strSQL = "select max(zhangh) from adshq"
rs.CursorLocation = adUseClient
'假设con是已经打开的连接
rs.Open strSQL, con, adOpenStatic, adLockReadOnly
If rs.RecordCount < 1 Then
newid = 1
Else
newid = rs(0) + 1
End If
rs!zhangh = Str(newid)
End Sub