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
| string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
string contentType = FileUpload1.PostedFile.ContentType;
using (Stream fs = FileUpload1.PostedFile.InputStream)
{
using (BinaryReader br = new BinaryReader(fs))
{
byte[] bytes = br.ReadBytes((Int32)fs.Length);
// string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection cn = new SqlConnection("Data Source=OUSSAMA-PC;Initial Catalog=eva;Integrated Security=True"))
{
string query = ("insert into devis values ('" + type_soins + "','" + date_sejour + "','" + sexe + "','" + nom + "','" + prenom + "','" + date_naissance + "','" + email + "','" + gsm + "','" + adresse + "','" + code_postal + "','" + ville + "','" + pays + "','" + accompagner + "','" + nbr_personne + "','" + informations + "',@Name,@ContentType,@Data,'" + connu + "')");
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection=cn;
cmd.Parameters.AddWithValue("@Name", filename);
cmd.Parameters.AddWithValue("@ContentType", contentType);
cmd.Parameters.AddWithValue("@Data", bytes);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
}
}
Response.Redirect(Request.Url.AbsoluteUri); |
Partager