15-08-17, 11:37 PM
PHP كود :
For Each r As DataGridViewRow In dgvprodac.Rows
Dim ad As Integer = Val(r.Cells(0).Value)
Dim xt As Integer = Val(r.Cells(2).Value)
cmd.CommandText = String.Format(" UPDATE [tab_pro] SET [qty] = qty -{0} WHERE [id] = {1} ", xt, ad, con)
cmd.ExecuteNonQuery()
Next
ده الكود وشغال فى فورم تانى عادى ملحق بصورة الخطا