Member Avatar for Naveen_16

value of life certificate is not updating through this code.
myconn.Open()

        cmd.Connection = myconn


    cmd.CommandText = " UPDATE Pension_Master SET  l_cer='" & l_cer & "',validfrom=convert(datetime,'" & validfrom.Date & "',101)," & _
    "validto=convert(datetime,'" & validto.Date & "',101) WHERE ppo_no  = ' " & TextBox1.Text & "'"
    If (payment_register.Visible = True) Then
        payment_register.TextBox4.Text = Me.RadioButton6.Text
    End If
    cmd.ExecuteNonQuery()
    myconn.Close()
  • 2 Contributors
  • 1 Reply
  • 336 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

Change it to

Dim cmd As String = " UPDATE Pension_Master SET  l_cer='" & l_cer & "',validfrom=convert(datetime,'" & validfrom.Date & "',101)," & _
"validto=convert(datetime,'" & validto.Date & "',101) WHERE ppo_no  = ' " & TextBox1.Text & "'"
Debug.WriteLine(cmd)

and post the output here. You might also try (before doing the update) selecting the records you want to modify and seeing if any records are actually returned. Perhaps the reason the update isn't doing anything is that no records are being selected.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.