object reference not set to an instance of object

sef, If the problem is with Database return results, I presume it is in this scenario:

   dsData = getSQLData(conn,sql, blah,blah....)
   dt = dsData.Tables(0)  'Perhaps the obj ref not set is occurring here

To fix that:

  dsData = getSQLData(conn,sql, blah,blah....)
   If dsData.Tables.Count = 0 Then Exit Sub
   dt = dsData.Tables(0)  'Perhaps the obj ref not set is occurring here

edit: added code formatting tags …

Related Posts:

  1. Sleep function Visual Basic
  2. lists and arrays in VBA
  3. To get a random integer value between 1 and N (inclusive) you can use the following.
  4. How to implement class constructor in Visual Basic?
  5. How to use \n new line in VB msgbox() …?
  6. VB6 to VB.net conversion
  7. Wait .5 seconds before continuing code VB.net
  8. How do I convert from a string to an integer in Visual Basic?
  9. Read a file line by line with VB.NET
  10. Reference to a non-shared member requires an object reference occurs when calling public sub
  11. Python: Where does if-endif-statement end?
  12. Unrecognized database format’C:\…..\Employees.accdb for Microsoft Access Database File?
  13. Declare global variables in Visual Studio 2010 and VB.NET
  14. no value given for one or more required parameters
  15. What is a NullReferenceException, and how do I fix it?
  16. HTML encoding issues – “” character showing up instead of ” “
  17. What is a NullReferenceException, and how do I fix it?
  18. How do I get my C# program to sleep for 50 msec?
  19. Converting string to byte array in C#
  20. Exception of type ‘System.OutOfMemoryException’ was thrown.
  21. Windows Application has stopped working :: Event Name CLR20r3
  22. Why is Dictionary preferred over Hashtable in C#?
  23. How does the “Using” statement translate from C# to VB?
  24. How do I create a Shared Code project (.shproj)
  25. What is the C# version of VB.net’s InputDialog?
  26. Cannot access a disposed object – How to fix?
  27. Cannot access a disposed object – How to fix?
  28. How should I cast in VB.NET?
  29. .NET graph library around?
  30. VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
  31. How to enable assembly bind failure logging (Fusion) in .NET
  32. Strip double quotes from a string in .NET
  33. When should I use a List vs a LinkedList

Leave a Comment

tech