Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Update
Message
De
12/02/2005 19:25:12
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Titre:
Database Update
Versions des environnements
Environment:
C# 1.1
OS:
Windows XP SP2
Database:
Jet/Access Engine
Divers
Thread ID:
00986360
Message ID:
00986360
Vues:
52
Hi All,

I'm trying to do a database update however when I attempt to do this I get the error:
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Here is the code I am using to do the update:
OleDbConnection objConn = new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
OleDbCommand objComm = new OleDbCommand("UPDATE Keys SET Page = 3", objConn);
objComm.Connection.Open();
objComm.ExecuteNonQuery();
objConn.Close();
What have I done wrong here?

As always any help is appreciated.

Many Thanks,
Tarran
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform