Monday, 3 September 2012

Records Affected






I was wondering today the best way to get the number of records affected by an update query in VB.NET

The answer is of cause

Dim recordsaffected  as Integer= MyCommandObject.ExecuteNonQuery()



Works a treat  thanks to all those other post out there found via Google the result was  found at

http://stackoverflow.com



-
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Samsung Android Keyboard

  If you have a Samsung phone or pad and the keyboard is set to Google give the Samsung one a try. Just go into the keyboard settings and ...

  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • DCOB Fault
    If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
  • Restore Windows App after a Crash.
    If you have a situation that requires an application to always be up then try   Restart program after a crash downloadable from  https://w-s...