class ClassAcces
{
private static byte[] imagetoByte(Image img)
{
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
return ms.ToArray();
}
static SqlConnection conn = new SqlConnection(EssaieImage.Properties.Settings.Default.ImageBDConnectionString);
public static int EditImage(int? id, string imagename, Image picture)
{
Byte[] img = imagetoByte(picture);
SqlCommand cmd = new SqlCommand("EditImage", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@imagename", imagename);
cmd.Parameters.AddWithValue("@picture", img);
if (conn.State == ConnectionState.Closed)
conn.Open();
int M = cmd.ExecuteNonQuery();
conn.Close();
return M;
priere de maidée ces trés urgent