[أبو نوره]

مرحبا اخى

PHP كود :

Using conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database1.accdb;Persist Security Info=False;")
           conn.Open()
           For Each row As DataGridViewRow In DataGridView1.Rows
               If row.Cells(0).Value Is Nothing Then Exit For
               Using cmd As New OleDbCommand("UPDATE [Equpment] SET [Equ_Qantity]=[Equ_Qantity] - @Equ_Qantity WHERE [Equ_ID]=@Equ_ID", conn)
                   cmd.Parameters.AddWithValue("@Equ_Qantity", val(row.Cells(2).Value) )
                   cmd.Parameters.AddWithValue("@Equ_ID", val(row.Cells(0).Value) )
                   cmd.ExecuteNonQuery()
               End Using
           Next
           conn.Close()
       End Using