Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
If ds.Tables(0).Rows.Count = 0 Then 'Nothing to Update... lblStatus.Text = "QuickBooks is reporting there are no items..." Exit Sub Else Dim y As Integer = ds.Tables(0).Rows.Count - 1 MsgBox("Number of Records to Update: " & y) For x = 0 To y Sql = "Update products set stock = " & ds.Tables(0).Rows(x).Item("QuantityOnHand") & " where sku = '" & ds.Tables(0).Rows(x).Item("Name") & "'" cmd = New SqlCommand(Sql, sqlConn) lblStatus.Text = "Now updating record: " & x & " of " & y & "." cmd.ExecuteNonQuery() Next End If
|How do I compare two xml files and remove all data elements in file2 not found in file1 using VB.NET||6||40|
|Connection String to remote Server not working||3||33|
|ASP.net markup problem with table alignment||2||11|
|ASP.net stop dynamically added controls dissapering on postback||2||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!