salut tout le monde,
j'ai un autre pb lors d'insertion, le code insert deux enregistrement après affiche l'erreur trop de valeurs voici le code:
string querystring3, queryString1;
queryString1 =
"select ID_REGARD,CENTRE,COMMUNE,ACC_REG,RELEVE,DEBIT,TRAFIC,METEO,TYPE_TAMPN,ENC_AGENT,ENC_OBSRVT,EAU_CLAIRE,NAT_DEPOT,PROF_REG,ENC_REG,ACC_REG,CENTRE,ENC_DATE,ACC_VEHCLE from ENCRASS";
OleDbCommand cmd = new OleDbCommand(queryString1);
cmd.Connection = connectAcc;
connectOrcl.Open();
connectAcc.Open();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string Var_CENTRE,
Var_ID_REGARD,
Var_ENC_DATE,
// Var_ZONE,
Var_COMMUNE,
Var_ACC_REG,
Var_RELEVE,
Var_DEBIT,
Var_TRAFIC,
Var_METEO,
Var_TYPE_TAMPN,
Var_ENC_AGENT,
Var_ENC_OBSRVT,
Var_EAU_CLAIRE,
Var_NAT_DEPOT,
Var_PROF_REG,
Var_ENC_REG,
Var_ACC_VEHCLE;
Var_ID_REGARD = reader["ID_REGARD"].ToString();
Var_CENTRE = reader["CENTRE"].ToString();
Var_ENC_DATE = reader["ENC_DATE"].ToString();
// Var_ZONE = reader["ZONE"].ToString();
Var_COMMUNE = reader["COMMUNE"].ToString();
Var_ACC_REG = reader["ACC_REG"].ToString();
Var_RELEVE = reader["RELEVE"].ToString();
Var_DEBIT = reader["DEBIT"].ToString();
Var_TRAFIC = reader["TRAFIC"].ToString();
Var_METEO = reader["METEO"].ToString();
Var_TYPE_TAMPN = reader["TYPE_TAMPN"].ToString();
Var_ENC_AGENT = reader["ENC_AGENT"].ToString();
Var_ENC_OBSRVT = reader["ENC_OBSRVT"].ToString();
Var_EAU_CLAIRE = reader["EAU_CLAIRE"].ToString();
Var_NAT_DEPOT = reader["NAT_DEPOT"].ToString();
Var_PROF_REG = reader["PROF_REG"].ToString();
Var_ENC_REG = reader["ENC_REG"].ToString();
Var_ACC_VEHCLE = reader["ACC_VEHCLE"].ToString();
querystring3 =
"insert into ETAT_ACTUEL_REGARD_TST (ID_REGARD,CENTRE,COMMUNE,ACC_REG,RELEVE,DEBIT,TRAFIC,METEO,TYPE_TAMPN,ENC_AGENT,ENC_OBSRVT,EAU_CLAIRE,NAT_DEPOT,PROF_REG,ENC_REG,ENC_DATE,ACC_VEHCLE) values (" + Var_ID_REGARD + ",'" + Var_CENTRE + "','" + Var_COMMUNE + "','" + Var_ACC_REG + "','" + Var_RELEVE + "','" + Var_DEBIT + "','" + Var_TRAFIC + "','" + Var_METEO + "','" + Var_TYPE_TAMPN + "','" + Var_ENC_AGENT + "','" + Var_ENC_OBSRVT + "','" + Var_EAU_CLAIRE + "','" + Var_NAT_DEPOT + "'," + Var_PROF_REG + "," + Var_ENC_REG + ",'" + Var_ENC_DATE + "','" + Var_ACC_VEHCLE + "')";
OracleCommand command = new OracleCommand(querystring3);
command.Connection = connectOrcl;
command.ExecuteNonQuery();
//OracleDataReader reader1 = command.ExecuteReader();
//reader1.Read();
}
reader.Close();
connectOrcl.Close(); //Déconnexion de la base de données OracleClient
connectAcc.Close(); //Déconnexion de la base de données Access
#endregion
return "Vous êtes Connecté";
}
catch (Exception ex)
{
return ex.Message;
}
}
}
}