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 33 34 35
|
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If CType(FormView1.FindControl("FileUpload2"), FileUpload).HasFile Then
Dim fichier As String = CType(FormView1.FindControl("FileUpload2"), FileUpload).FileName
Me.SqlDSEmploiStagiaire.InsertParameters("NomFichier").DefaultValue = fichier
Me.SqlDSEmploiStagiaire.InsertParameters("personnel").DefaultValue = Me.User.Identity.Name
Me.FormView1.DefaultMode = FormViewMode.ReadOnly
Else
MsgBox("Le chemin fournis est incorrect", MsgBoxStyle.Critical, "Erreur")
End If
End Sub
Protected Sub SqlDSEmploiStagiaire_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDSEmploiStagiaire.Inserted
Dim MEM As IO.Stream = CType(FormView1.FindControl("FileUpload2"), FileUpload).PostedFile.InputStream
Dim arraybayte As Byte() = New Byte(MEM.Length) {}
MEM.Read(arraybayte, 0, arraybayte.Length)
Dim SQLCOMMAND As New SqlClient.SqlCommand
Dim CONSTRING As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"
Dim sqlcon As New SqlClient.SqlConnection(CONSTRING)
With SQLCOMMAND
.Connection = sqlcon
.CommandType = Data.CommandType.Text
.CommandText = "UPDATE EmploiTemps SET Fichier =@fichier WHERE (Etablissement = @etab) AND (Filiere = @fil) AND (Groupe = @grp) AND (Annee = @ann) AND (Massehoraire = @mh)"
.Parameters.Add("@etab", SqlDbType.Decimal).Value = CType(FormView1.FindControl("DropDownList2"), DropDownList).SelectedValue
.Parameters.Add("@fil", SqlDbType.NVarChar, 50).Value = CType(FormView1.FindControl("DropDownList3"), DropDownList).SelectedValue
.Parameters.Add("@grp", SqlDbType.NVarChar, 50).Value = CType(FormView1.FindControl("DropDownList4"), DropDownList).SelectedValue
.Parameters.Add("@ann", SqlDbType.Int).Value = CType(FormView1.FindControl("DropDownList5"), DropDownList).SelectedValue
.Parameters.Add("@mh", SqlDbType.NVarChar, 50).Value = CType(FormView1.FindControl("MassehoraireTextBox"), TextBox).Text
.Parameters.Add("@fichier", SqlDbType.Image).Value = arraybayte
End With
sqlcon.Open()
SQLCOMMAND.ExecuteNonQuery()
sqlcon.Close()
End Sub |
Partager