1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| OdbcConnection* myConn;
try
{
myConn = new OdbcConnection ("DSN=dosage");
}
catch(...)
{
}
//string requete = "insert into password (nom , prenom, niveau, motdepasse) values('"+name+"','"+surname+"','"+nivo+"','"+mdp+"')" ;
string requete = "delete * from password"; //where nom='Gourmelon'";
OdbcCommand* myOdbcCommand = new OdbcCommand( requete.c_str() );
//OdbcCommand* myOdbcCommand = new OdbcCommand("delete from password",myConn);
myOdbcCommand->Connection = myConn;
//myOdbcCommand->Connection = myConn;
//OdbcDataReader* myReader;
int i;
try
{
myOdbcCommand->Connection->Open();
i = myOdbcCommand->ExecuteNonQuery();
}
catch (OdbcException* e)
{
String* errorMessages = S"";
for (int i=0 ; i< e->Errors->Count; i++)
{
errorMessages = String::Concat(S"Index #: ", __box(i), S"\n",S"Message: ",e->Errors->Item[i]->Message, S"\n", S"NativeError: ", e->Errors->Item[i]->Message, S"\n", S" Source: ", e->Errors->Item[i]->Source, S"\n", S"SQL: ", e->Errors->Item[i]->SQLState, S"\n");
}
System::Diagnostics::EventLog* log = new System::Diagnostics::EventLog();
log->Source = S"La base de donnée du dosage";
log->WriteEntry(errorMessages);
}
myOdbcCommand->Connection->Close(); |
Partager