这样对吗?错在哪?
lcge 2004-08-30 10:43:30 问题一
Dim n As String
n = "select 序号 from 订单名细表 where 订单号='" & Trim(Me.Label29.Text) & "'"
Dim nadper As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(n, dataconn)
dataset.Clear()
nadper.Fill(dataset, "订单名细表")
ynum = dataset.Tables(0).Rows(0).Item(0)
出错提示:
其他信息:在位置 0 处没有任何行。
问题二
Dim m As String
For yynum = ynum To dataset.tables(0).rows.count
mm = yynum + 1
m = "update 订单名细表 set 序号='" & yynum & "' where 序号='" & mm & "'"
Dim mcomm As New OleDb.OleDbCommand(m, dataconn)
mcomm.Connection.Close()
mcomm.Connection.Open()
mcomm.ExecuteNonQuery()
mcomm.Connection.Close()
Next
目的是让大于yynum序号后面的序号减1更新后面的序号!