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
| String _strSql = "INSERT INTO Films ( FI_Num, FI_Titre, FI_Annee_sortie, FI_Date_Parution, FI_Date_Achat, FI_Duree, FI_Zone, FI_Realisateur, FI_Studio, FI_Genre, FI_Resume, FI_Modif_Date, FI_Modif_Qui, FI_Jacquette)"
+ " VALUES ( @FI_Num, @FI_Titre, @FI_Annee_sortie, @FI_Date_Parution, @FI_Date_Achat, @FI_Duree, @FI_Zone, @FI_Realisateur, @FI_Studio, @FI_Genre, @FI_Resume, @FI_Modif_Date, @FI_Modif_Qui, @FI_Jacquette);";
Int32 RetourValeurInsertion = 0;
try
{
using (DbConnection cn = new OleDbConnection(methode.doConnectionString()))
{
using (DbCommand cmd = new OleDbCommand(_strSql, (OleDbConnection)cn))
{
cmd.CommandType = CommandType.Text;
.....
DbParameter FI_Jacquette = new OleDbParameter("@FI_Jacquette", OleDbType.Binary);
FI_Jacquette.Value = fi_Jacquette;
cmd.Parameters.Add(FI_Jacquette);
cn.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT @@IDENTITY";
RetourValeurInsertion = (Int32)cmd.ExecuteScalar();
cn.Close();
return RetourValeurInsertion;
}
}
}
catch (Exception e)
{ |
Partager