Update query?

[lynque]

Hello all,

I'm new to C# and am having some trouble with an update query

// create DB connection
string mydbdsn="server=SERVER; database=DB; user id=USER; pwd=PW;";
SqlConnection connection = new SqlConnection(mydbdsn);
connection.Open();

strNewABS="UPDATE <TABLE> SET <COLUMN> = 'L' WHERE ID = 1"; 
SqlCommand updateCommand = new SqlCommand(strNewABS, connection);
updateCommand.ExecuteNonQuery();

The update works in Query Analyser but not on the page.

Any help is much appreciated

 

[chiph]

Wrap this code in a try..catch block, and then paste in the contents of the exception's message property. Once we know what the exact error is, we might could help.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first