Updatecommand error

[Guest]

Hello

In wrote this in VB code:
DAComent.UpdateCommand.CommandText = "UPDATE coment SET estmensag='P' WHERE
nomepess LIKE '%" & Trim(TextBox2.Text) & "%' AND emailpess LIKE '%" &
Trim(TextBox3.Text) & "%' AND mensagpess LIKE '%" & Trim(TextBox5.Text) & "%'"
DAComent.UpdateCommand.ExecuteNonQuery()

....and a error ocurs:"Object reference not set to an instance of an object"

Whats that?

Thanks

 

[Sahil Malik]

This means -

Either DAComent or DAComent.UpdateCommand or both have not been set to an
object instance that you have created via a "new" or alternate method. It
might even be that TextBox2/3/5 might not be instantiated.

Put a breakpoint and evaluate their being null or not null right before the
error occurs.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

 

[W.G. Ryan eMVP]

Vitorjol - Like Sahil mentions, one of the objects isn't instantiated.
Before each one , put in Debug.Assert and test for Is Nothing. However I
think it DAComment was null then you'd be getting the exception on the first
line, not the second one.

however do yourself a favor and lose the Dynamic SQL - it will come back to
bite you if you don't.

Also, if you're using a DataAdapter to handle your updates (particularly if
you used it for Select statements), then you may want to just call
DAComent.Update(DataTableName)