Please help with Dataset Problem

[Justin]

I am trying to do a simple update of a single row with the dataset below but
I keep getting this error:

"System.NullReferenceException: Object reference not set to an instance of
an object."

Here is the code:

Me.sqlDataAdapter1.Fill(DataSet1, "Queue")

Dim QueueRow As DataRow
QueueRow = DataSet1.Tables("Queue").Rows.Find(myCustomerID)

ERROR HERE< QueueRow(month) = ProductList.ToString()

Me.sqlDataAdapter1.Update(DataSet1, "Queue")

I have tried replacing all variables with strings with no luck

Please Help!

Thanks, Justin.

[Karl Seguin]

Justin:
Seems to me that your Find didn't find anything and thus QueueRow is
nothing...typically you check for nothing in this case:

if not QueueRow is nothing then
'get value
else
'throw an exception? use a default?
end if

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

I am trying to do a simple update of a single row with the dataset below but I keep getting this error:

"System.NullReferenceException: Object reference not set to an instance of
an object."

Here is the code:

Me.sqlDataAdapter1.Fill(DataSet1, "Queue")

Dim QueueRow As DataRow
QueueRow =

DataSet1.Tables("Queue").Rows.Find(myCustomerID)

ERROR HERE< QueueRow(month) = ProductList.ToString()

Me.sqlDataAdapter1.Update(DataSet1, "Queue")

I have tried replacing all variables with strings with no luck

Please Help!

Thanks, Justin.

[Justin]

Ok, with you help I think I have found the problem I just don't know how to
solve it.

I have set Rows.Find(myCustomerID) to Rows.Find("4") and it works fine but
as you know when I use a variable it does not work, I test to see if the
myCustomerID is empty by displaying it in a label control and it did so the
variable is not empty.

I am Lost.

THanks, Justin.
"Karl Seguin" wrote:

Justin:
Seems to me that your Find didn't find anything and thus QueueRow is
nothing...typically you check for nothing in this case:

if not QueueRow is nothing then
'get value
else
'throw an exception? use a default?
end if

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

I am trying to do a simple update of a single row with the dataset below

but

I keep getting this error:

"System.NullReferenceException: Object reference not set to an instance of
an object."

Here is the code:

Me.sqlDataAdapter1.Fill(DataSet1, "Queue")

Dim QueueRow As DataRow
QueueRow =

DataSet1.Tables("Queue").Rows.Find(myCustomerID)

ERROR HERE< QueueRow(month) = ProductList.ToString()

Me.sqlDataAdapter1.Update(DataSet1, "Queue")

I have tried replacing all variables with strings with no luck

Please Help!

Thanks, Justin.

[Karl Seguin]

Justin:
Off the top of my head the only thing I can think of is that there's some
weird type mismatch going on. is myCustomerID an integer or a string? By
the name i'd assume it was an integer, but it seemed to have worked when you
used a string "4" if it is an integer does it work when you ToString()
it...or does Rows.Find(4) work ?

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:4B**********************************@microsof t.com...

Ok, with you help I think I have found the problem I just don't know how to solve it.

I have set Rows.Find(myCustomerID) to Rows.Find("4") and it works fine but
as you know when I use a variable it does not work, I test to see if the
myCustomerID is empty by displaying it in a label control and it did so the variable is not empty.

I am Lost.

THanks, Justin.
"Karl Seguin" wrote:

Justin:
Seems to me that your Find didn't find anything and thus QueueRow is
nothing...typically you check for nothing in this case:

if not QueueRow is nothing then
'get value
else
'throw an exception? use a default?
end if

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

I am trying to do a simple update of a single row with the dataset below

but

I keep getting this error:

"System.NullReferenceException: Object reference not set to an

instance of an object."

Here is the code:

Me.sqlDataAdapter1.Fill(DataSet1, "Queue")

Dim QueueRow As DataRow
QueueRow =

DataSet1.Tables("Queue").Rows.Find(myCustomerID)

>ERROR HERE< QueueRow(month) = ProductList.ToString()

Me.sqlDataAdapter1.Update(DataSet1, "Queue")

I have tried replacing all variables with strings with no luck

Please Help!

Thanks, Justin.