Private Sub Btn_Save_Click(sender As System.Object, e As System.EventArgs) Handles Btn_Save.Click
If TB_Surname.Text <> "" And TB_Name.Text <> "" Then
'Remplacer l'apostrophe par 2 apostrophes
TB_Surname.Text = Replace(TB_Surname.Text, "'", "''")
TB_Name.Text = Replace(TB_Name.Text, "'", "''")
TB_Function.Text = Replace(TB_Function.Text, "'", "''")
TB_Email.Text = Replace(TB_Email.Text, "'", "''")
TB_Surnom.Text = Replace(TB_Surnom.Text, "'", "''")
TB_Office.Text = Replace(TB_Office.Text, "'", "''")
TB_Portable.Text = Replace(TB_Portable.Text, "'", "''")
CB_Choice_Plant.Text = Replace(CB_Choice_Plant.Text, "'", "''")
Try
' Commande SQL pour Prendre l ID du pays
Req_sql_string = "Select Table_Pays.PaysID " & _
" FROM Table_Pays " & _
" WHERE Table_Pays.Pays = '" & CB_Choice_Plant.Text & "'"
SourceBaseMethod.Open()
MycommandMethod.CommandText = Req_sql_string
Pays = MycommandMethod.ExecuteScalar
'MessageBox.Show(Pays.ToString())
SourceBaseMethod.Close()
Catch ex As Exception
MsgBox(ex.Message)
'SourceBaseMethod.Close()
End Try
Try
' Commande SQL pour mettre a jour tous les champs de la personne sélectionné
Req_sql_string = "update Personnel set Personnel.usine = '" & Pays & "' , Personnel.nom ='" & TB_Surname.Text & "' , Personnel.prenom ='" & TB_Name.Text & "' , Personnel.fonction ='" & TB_Function.Text & "' , Personnel.adresse_mail ='" & TB_Email.Text & "' , Personnel.surnom ='" & TB_Surnom.Text & "' , Personnel.Actif ='" & Actif & "' , Personnel.telephone_fixe ='" & TB_Office.Text & "', Personnel.telephone_port ='" & TB_Portable.Text & "', Personnel.Emetteur_de_Devis ='" & Emetteur_Devis & "' " & _
"WHERE Personnel.ID_Personne = '" & TB_ID.Text & "'"
SourceBaseMethod.Open()
MycommandMethod.CommandText = Req_sql_string
Dim NbreLignesAffectés As Integer
NbreLignesAffectés = MycommandMethod.ExecuteNonQuery()
'MsgBox("Number of Lines Updated : " & NbreLignesAffectés)
SourceBaseMethod.Close()
Catch ex As Exception
MsgBox(ex.Message)
SourceBaseMethod.Close()
End Try
Call BDD_Update()
End If
End Sub
Private Sub BDD_Update()
Try
'Dim strConnexion As String = "Data Source=localhost; Integrated Security=SSPI;" + "Initial Catalog=Database1.sdf"
Dim strConnexion As String = "Data Source=|DataDirectory|\Database1.sdf"
Dim strRequete As String = "SELECT * FROM Personnel ORDER BY ID_Personne"
Dim oConnection As New SqlCeConnection(strConnexion)
oConnection.Open()
' Chargement de la liste des catégories dans oDataSet
Dim oSqlDataAdapter As New SqlCeDataAdapter(strRequete, strConnexion)
Dim oDataSet As New DataSet("Personnel")
oSqlDataAdapter.Fill(oDataSet, "Personnel")
' Mise à jour de la source de données à partir du DataSet
oSqlDataAdapter.Update(oDataSet, "Personnel")
' Rechargement des données de la source mise à jour
oDataSet.Clear()
oSqlDataAdapter.Fill(oDataSet, "Personnel")
'Dim Req_Update As String = "UPDATE Personnel SET usine = 3 WHERE ID_Personne = 1"
'oSqlDataAdapter.UpdateCommand.Parameters.Add("@usine", SqlDbType.Int, 4, "Usine")
Dim Builder As New SqlCeCommandBuilder(oSqlDataAdapter)
oSqlDataAdapter.UpdateCommand = Builder.GetUpdateCommand
oSqlDataAdapter.Update(oDataSet, "Personnel")
oConnection.Close()
Catch e As Exception
MsgBox(e.Message)
End Try
End Sub
Dim dr As DataRow
dr = oDataSet.Tables("Personnel").Rows(x)
dr(field1) = blabla
dr(field2) = blabla
etc.....
try
oSqlDataAdapter.Update(oDataSet, "Personnel")
'On vide le DataSet et on le 'recharge' de nouveau.
oDataSet.Clear()
oSqlDataAdapter.Fill(oDataSet, "Personnel")
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
dr = oDataSet.Tables("Personnel").Rows(x)
Private Sub BackupDatas_to_BDD()
Dim dr As DataRow
Dim byteArray As Byte() = {&H0, &H0}
Dim x As Integer
Dim oDataSet As New DataSet("Personnel")
x = TB_ID.Text 'N° ID de la personne
dr = oDataSet.Tables("Personnel").Rows(x)
dr("usine") = 1
dr("nom") = "TEST"
dr("prenom") = "TEST"
dr("fonction") = "TEST"
dr("adresse_mail") = "TEST"
dr("surnom") = "TEST"
dr("Actif") = 1
dr("telephone_fixe") = "TEST"
dr("telephone_port") = "TEST"
dr("photo") = byteArray
dr("Emetteur_de_Devis") = 1
Try
Dim strConnexion As String = "Data Source=|DataDirectory|\Database1.sdf"
Dim strRequete As String = "SELECT * FROM Personnel ORDER BY ID_Personne"
Dim oConnection As New SqlCeConnection(strConnexion)
oConnection.Open()
' Chargement de la liste des catégories dans oDataSet
Dim oSqlDataAdapter As New SqlCeDataAdapter(strRequete, strConnexion)
oSqlDataAdapter.Update(oDataSet, "Personnel")
'On vide le DataSet et on le 'recharge' de nouveau.
oDataSet.Clear()
oSqlDataAdapter.Fill(oDataSet, "Personnel")
oConnection.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub BackupDatas_to_BDD()
Try
Dim strConnexion As String = "Data Source=|DataDirectory|\Database1.sdf"
Dim strRequete As String = "SELECT * FROM Personnel ORDER BY ID_Personne"
Dim oConnection As New SqlCeConnection(strConnexion)
oConnection.Open()
' Chargement de la liste des catégories dans oDataSet
Dim oSqlDataAdapter As New SqlCeDataAdapter(strRequete, strConnexion)
Dim oDataSet As New DataSet("Personnel")
oSqlDataAdapter.Fill(oDataSet, "Personnel")
x = TB_ID.Text 'N° ID de la personne
dr = oDataSet.Tables("Personnel").Rows(x)
dr("usine") = 1
dr("nom") = "TEST"
dr("prenom") = "TEST"
dr("fonction") = "TEST"
dr("adresse_mail") = "TEST"
dr("surnom") = "TEST"
dr("Actif") = 1
dr("telephone_fixe") = "TEST"
dr("telephone_port") = "TEST"
dr("photo") = byteArray
dr("Emetteur_de_Devis") = 1
oSqlDataAdapter.Update(oDataSet, "Personnel")
'On vide le DataSet et on le 'recharge' de nouveau.
oDataSet.Clear()
oSqlDataAdapter.Fill(oDataSet, "Personnel")
oConnection.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
x = TB_ID.Text 'N° ID de la personne
For x As Integer = 0 To ds.Tables("Personnel").Rows.Count - 1
If ds.Tables("Personnel").Rows(x)("ID_Personne") = TB_ID.Text Then
Exit For
End If
Next
dr = oDataSet.Tables("Personnel").Rows(x)
dr = oDataSet.Tables("Personnel").Rows(x)
dr = oDataSet.Tables("Personnel").Rows(4)
Private Sub BackupDatas_to_BDD()
Try
' Commande SQL pour Prendre l'ID du pays
Req_sql_string = "Select Table_Pays.PaysID " & _
" FROM Table_Pays " & _
" WHERE Table_Pays.Pays = '" & CB_Choice_Plant.Text & "'"
SourceBaseMethod.Open()
MycommandMethod.CommandText = Req_sql_string
Pays = MycommandMethod.ExecuteScalar
'MessageBox.Show(Pays.ToString())
SourceBaseMethod.Close()
Catch ex As Exception
MsgBox(ex.Message)
'SourceBaseMethod.Close()
End Try
Dim connectionString As String
Dim fileName As String = "Database1.sdf"
connectionString = String.Format("DataSource=""{0}"";", fileName)
Dim connex As New SqlCeConnection(connectionString)
If connex.State = ConnectionState.Closed Then
connex.Open()
End If
Try
Dim cmd As New SqlCeCommand()
Req_sql_string = "update Personnel set Personnel.usine = '" & Pays & "' , Personnel.nom ='" & TB_Surname.Text & "' , Personnel.prenom ='" & TB_Name.Text & "' , Personnel.fonction ='" & TB_Function.Text & "' , Personnel.adresse_mail ='" & TB_Email.Text & "' , Personnel.surnom ='" & TB_Surnom.Text & "' , Personnel.Actif ='" & Actif & "' , Personnel.telephone_fixe ='" & TB_Office.Text & "', Personnel.telephone_port ='" & TB_Portable.Text & "', Personnel.Emetteur_de_Devis ='" & Emetteur_Devis & "' " & _
"WHERE Personnel.ID_Personne = '" & TB_ID.Text & "'"
cmd = New SqlCeCommand(Req_sql_string, connex)
cmd.Parameters.Add(New SqlCeParameter("@usine", SqlDbType.Int, 4))
cmd.Parameters.Add(New SqlCeParameter("@nom", SqlDbType.NVarChar, 100))
cmd.Parameters.Add(New SqlCeParameter("@prenom", SqlDbType.NVarChar, 100))
cmd.Parameters.Add(New SqlCeParameter("@fonction", SqlDbType.NVarChar, 200))
cmd.Parameters.Add(New SqlCeParameter("@adresse_mail", SqlDbType.NVarChar, 200))
cmd.Parameters.Add(New SqlCeParameter("@surnom", SqlDbType.NVarChar, 200))
cmd.Parameters.Add(New SqlCeParameter("@Actif", SqlDbType.Int, 4))
cmd.Parameters.Add(New SqlCeParameter("@telephone_fixe", SqlDbType.NVarChar, 40))
cmd.Parameters.Add(New SqlCeParameter("@telephone_port", SqlDbType.NVarChar, 40))
cmd.Parameters.Add(New SqlCeParameter("@photo", SqlDbType.Image, 16))
cmd.Parameters.Add(New SqlCeParameter("@Emetteur_de_Devis", SqlDbType.Int, 4))
cmd.ExecuteNonQuery()
connex.Close()
Catch
MsgBox(Err.Description)
End Try
End Sub
update Personnel set Personnel.usine = '"
update Personnel set Personnel.usine = @usine AND Personnel.nom =@nom
6 sept. 2016 à 10:06
Merci de ta réponse. J'ai enlevé l'insert mais comme tu t'en douté, ça ne résout pas mon soucis
Voici le nouveau code