Getting NullReferenceException Error

[lorena]

All I want to do is put data into a grid. Here is my code:

Sub BindData()
    Dim strConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\intranet\databases\open_en.mdb"
    Dim objConn As New OleDb.OleDbConnection(strConnString)

    Dim strSQL As String = "SELECT  * FROM InsChange"
    Dim objCommand As New OleDb.OleDbCommand(strSQL, objConn)

    Dim objDA As New OleDb.OleDbDataAdapter
    objDA.SelectCommand = objCommand

    Dim objDS As New DataSet
    objDA.Fill(objDS)
    objConn.Close()
  
    grdRecs.DataSource = objDS
    grdRecs.DataBind()
  End Sub

I keep getting "Object reference not set to an instance of an object"
Any help would be appreciated.

 

[PlausiblyDamp]

Where do you keep getting the error?

 

[lorena]

The page builds with no errors. The error occurs when I try to preview the page in a browser window.
Here is the stack trace:
NullReferenceException: Object reference not set to an instance of an object.]
webforms.oe_test.BindData() in J:\WebForms\oe\oe_test.aspx.vb:50
webforms.oe_test.Page_Load(Object sender, EventArgs e) in J:\WebForms\oe\oe_test.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

Line 50 is

grdRecs.DataSource = objDS

I checked my query and, in the access database, it pulls the data in correctly but it looks like the dataset is null if I am reading it right.

 

[PlausiblyDamp]

If you put a breakpoint on that line and run the code what value does the debugger display for objDS and grdRecs?

 

[lorena]

I cant run the debugger. I am doing development on a remote server and have never been able to get the debugger to work

 

[PlausiblyDamp]

In that case check if either of them is nothing and drop a debug message to the page telling you if either of them is nothing.

 

[lorena]

Well, this is really bizarre. I started by commenting all the code out and adding it back a line at a time, changing nothing and now it works!
*argh*
thanks for your help though. I just wish I knew why it works now.