... comment on relie entre la propriété et la date pour que faux devient vrai ...
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question... comment on relie entre la propriété et la date pour que faux devient vrai ...
Quel est ton gestionnaire de base de données ?
As-tu regardé la requête UPDATE ?
UPDATE document set document à evacuer = true where date=....
INSERT INTO Document (numero_document,date_entrée) VALUES ('" & num.text & "','"& convert(DateTime,datedoc.text, "dd-MM-yyyy ")&"'
cmd1.CommandText "UPDATE document SET document à evacuer true WHERE datedoc.Text = DateAdd(DateInterval.Day, 365, dateart)"
Try Dim strConnexion As String = "" Dim Connsql As New SqlConnection(strConnexion) Dim strcmd As New SqlCommand Connsql.Open() Dim strRequete As String = "SELECT * FROM document WHERE document à evacuer=true" strcmd.Connection = Connsql strcmd.CommandText = strRequete strcmd.ExecuteNonQuery() DataGridView1.DataSource = strcmd strcmd.Connection.Close() Connsql.Close() Catch ex As Exception End Try End Sub
Bouton ajout document(contrôle du date d'ajout) cmd1.CommandText "UPDATE document SET document à evacuer true WHERE datedoc.Text = DateAdd(DateInterval.Day, 365, dateart)"
Private Sub bouttonaffiche_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bouttonaffiche.Click Try Dim strConnexion As String = "" Dim Connsql As New SqlConnection(strConnexion) Dim strcmd As New SqlCommand Connsql.Open() Dim strRequete As String = "SELECT * FROM document WHERE document à evacuer=true" strcmd.Connection = Connsql strcmd.CommandText = strRequete strcmd.ExecuteNonQuery() DataGridView1.DataSource = strcmd strcmd.Connection.Close() Connsql.Close() Catch ex As Exception End Try End Sub Private Sub Bouttonsup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Bouttonsup.Click For Each row As DataGridViewRow In DataGridView1.SelectedRows DataGridView1.Rows.Remove(row) Next End Sub
Code Visual Basic :
Bouton ajout document(contrôle du date d'ajout)
cmd1.CommandText "UPDATE document SET document à evacuer true WHERE datedoc.Text = DateAdd(DateInterval.Day, 365, dateart)"
Code Visual Basic :
Private Sub bouttonaffiche_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bouttonaffiche.Click
Try
Dim strConnexion As String = ""
Dim Connsql As New SqlConnection(strConnexion)
Dim strcmd As New SqlCommand
Connsql.Open()
Dim strRequete As String = "SELECT * FROM document WHERE document à evacuer=true"
strcmd.Connection = Connsql
strcmd.CommandText = strRequete
strcmd.ExecuteNonQuery()
DataGridView1.DataSource = strcmd
strcmd.Connection.Close()
Connsql.Close()
Catch ex As Exception
End Try
End Sub
Private Sub Bouttonsup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Bouttonsup.Click
For Each row As DataGridViewRow In DataGridView1.SelectedRows
DataGridView1.Rows.Remove(row)
Next
End Sub
Private Sub datp() Dim con As String = "" Dim connsql As New SqlConnection(con) Dim cmd As New SqlCommand Dim cmd1 As New SqlCommand Dim rqsql As String = "SELECT Date_entrée FROM document" Dim entree, sortie As DateTime Dim Diffirence As TimeSpan connsql.Open() cmd.Connection = connsql cmd.CommandText = rqsql entree = DateTime.Parse("rqsql") sortie = DateTime.Now Difference = sortie-entree connsql.Close() If Difference.TotalDays = 365 Then cmd1.CommandText "UPDATE document SET document_à_supprimertrue " End If End Sub
private sub datp() dim con as string = "" dim connsql as new sqlconnection(con) dim cmd as new sqlcommand dim cmd1 as new sqlcommand id_type='1' dim rqsql as string = "select date_entrée from document" ' where dim entree, sortie as datetime dim diffirence as timespan connsql.open() cmd.connection = connsql cmd.commandtext = rqsql dim date_entrée as date = cmd.executescalar() entree = datetime.parse(date_entrée) sortie = datetime.now diffirence = entree.subtract(sortie) msgbox("Le nombre du jours est ", diffirence.totaldays) if diffirence.totaldays = 365 then cmd1.commandtext "update document set document_à_supprimertrue " ' where id_type='1' cmd1.executenonquery() end if connsql.close() end sub
private sub datp() dim con as string = "" dim connsql as new sqlconnection(con) dim cmd as new sqlcommand dim cmd1 as new sqlcommand dim rqsql as string = "select date_entrée from document where id_type='1' " dim entree, sortie as datetime dim diffirence as timespan connsql.open() cmd.connection = connsql cmd.commandtext = rqsql dim date_entrée as date = cmd.executescalar() entree = datetime.parse(date_entrée) sortie = datetime.now diffirence = entree.subtract(sortie) msgbox("Le nombre du jours est ", diffirence.totaldays) if diffirence.totaldays = 365 then cmd1.commandtext "update document set document_à_supprimertrue where id_type='1' " cmd1.executenonquery() end if connsql.close() end sub