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()

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.