UPDATE query in ASP.NET

[Guest]

Using Query Builder, I wrote a simple UPDATE query to update a single record
in an Access 2000 database. The query works fine when I run it from the
Query Builder in a OleDbCommand object by right-clicking the mouse.

"UPDATE tblJournal SET eventDescrip='New entry for Monday' WHERE
(eventID=791)"

However, when I open the same connection and call the same command object
using a click event in a WebControls.Button, the program runs but the record
is not updated. Yes, I make a change to the query to test if anything is
getting updated. And yes, the click event is getting triggered. Am I
missing something basic here?

This is how I try to run the query in the button click event:

me.connJournal.Open()
me.cmUpdateQueryTest.ExecuteNonQuery()
me.connJournal.Close()

 

[i. Wiin]

Please post your entire code (of course protect any passwords).

 

[Kevin Spencer]

I don't see any association of your Command object to the Connection in your
posted code. In fact, I'm wondering why you're not throwing an exception
here.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living