Code :
try { //create the command object and store the sql query // Tableau d'octets representant l'image au format jpeg MemoryStream mstImage = new MemoryStream (); pbxImage.Image.Save(mstImage, System.Drawing.Imaging.ImageFormat.Jpeg); Byte[] bytImage = mstImage.GetBuffer(); aConnection.Open(); OleDbCommand cmdTestAccessImage = new OleDbCommand ("INSERT INTO personne([pseudo], [nom], [prenom], [photo], [date_naiss], [mail]) VALUES (?, ?, ?, ?, ?, ?)", aConnection ); //C'est ici que je remplis le parametre cmdTestAccessImage. Parameters. Add(new OleDbParameter ("photo", OleDbType. VarBinary, bytImage. Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, bytImage)); cmdTestAccessImage. Parameters. Add(new OleDbParameter ("pseudo", System. Data. OleDb. OleDbType. VarWChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, this.tab1txtboxPseudo.Text)); cmdTestAccessImage. Parameters. Add(new OleDbParameter ("nom", System. Data. OleDb. OleDbType. VarWChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, this.tab1txtBoxNom.Text)); cmdTestAccessImage. Parameters. Add(new OleDbParameter ("prenom", System. Data. OleDb. OleDbType. VarWChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, this.tab1txtboxPrenom.Text)); cmdTestAccessImage. Parameters. Add(new OleDbParameter ("date_naiss", System. Data. OleDb. OleDbType. DBTimeStamp, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, DateTime.Now.ToString())); cmdTestAccessImage. Parameters. Add(new OleDbParameter ("mail", System. Data. OleDb. OleDbType. VarWChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, "" )); cmdTestAccessImage.ExecuteNonQuery(); aConnection.Close();
|