Help Value cannot be null exception

[Jim]

I am experiancing a problem filling a dataset. I am getting a Value cannot be
null exception and can't figure out why. Here is the code what the heck could
be going on?

Dim conn As New SqlConnection(ConnectionString)
Dim adapter As New SqlDataAdapter
strSQL = "SELECT * FROM ChiefComplaints"
adapter.SelectCommand = New SqlCommand(strSQL, conn)
adapter.Fill(dataSet)

this is right out of the help section. I've tested the connection string and
it opens a connection with no problems.
--
Thanks, Jim

[Marina]

My ugess is that the 'dataSet' variable is null.

"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:8A**********************************@microsof t.com...

I am experiancing a problem filling a dataset. I am getting a Value cannot
be
null exception and can't figure out why. Here is the code what the heck
could
be going on?

Dim conn As New SqlConnection(ConnectionString)
Dim adapter As New SqlDataAdapter
strSQL = "SELECT * FROM ChiefComplaints"
adapter.SelectCommand = New SqlCommand(strSQL, conn)
adapter.Fill(dataSet)

this is right out of the help section. I've tested the connection string
and
it opens a connection with no problems.
--
Thanks, Jim