1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
if (Request.QueryString.Count > 0)
{
string[] ID_video = Request.QueryString.GetValues(0);
string filename = ConfigurationManager.AppSettings["CheminImageDVD"].ToString() + Téléchargement_image.FileName;
if (Téléchargement_image.HasFile == true)
{
Téléchargement_image.SaveAs(filename);
string image_req = "UPDATE [VidéoMania].[dbo].[VIDEO_Liste_Video] " +
"SET [Photo] = '" + filename + "'" +
"WHERE ID = '" + ID_video + "'";
SqlCommand Execute_requete = new SqlCommand(image_req, connection);
int nbsite = Execute_requete.ExecuteNonQuery();
}
}
} |