datagridview数据更新数据表问题?在线急等!!
我想把datagridview里的盘点数量更新覆盖库存表的库存量
datagridview里有 盘点单号,商品编号,盘点数量,库存量,报损数量,盘点时间这几列
我把盘点单号赋值为a,商品编号赋值为b
现在更新数据表是出错?以下是我的代码大家帮忙看下,谢谢!
Dim a, b As Integer
Dim strcon, strcmd As String
strcon = "Initial Catalog=blddatebase1;Data Source=(local);User ID=sa;Password=;"
Dim sqlcon As SqlConnection = New SqlConnection(strcon)
sqlcon.Open()
Dim i As Integer
For i = 0 To Me.DataGridView1.Rows.Count - 1
a = Me.DataGridView1.Item(1, i).Value
b = Me.DataGridView1.Item(2, i).Value
Dim sqlcmd As SqlCommand = New SqlCommand(strcmd, sqlcon)
sqlcmd.ExecuteNonQuery()
strcmd = "update spxinxi Set 库存量 = '" & b & "' where 商品编号='" & a & "'"
Next
MessageBox.Show("更新库存信息成功!", "提醒", MessageBoxButtons.OK, MessageBoxIcon.Information)
报错问题strcmd变量在赋值前已使用。
ExecuteNonQuery: CommandText 属性尚未初始化