Member Avatar for ggl0rd

i got problem to save the record after edit the record..

this the error
Operator '&' is not defined for string "UPDATE RekodAnggaran SET Nama='A" and type 'DataRowView'.

code save

Private Sub btnsimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsimpan.Click
        con.Open()
        [B]sql = ("UPDATE RekodAnggaran SET Nama='" & txtNama.Text & "', TarikhLahir='" & txtTarikhLahir.Text & "', Alamat='" & txtAlamat.Text & "',NoTelefon='" & txtNoTelefon.Text & "', Status='" & cmbStatus.SelectedItem & "', TarikhMI='" & DTPMI.Value.ToShortDateString & "', JPembayaran='" & cmbJPembayaran.SelectedItem & "', Pelan='" & cmbPelan.SelectedItem & "', Umur='" & cmbPremium.SelectedItem & "' WHERE [NoIC]='" & txtNoIC.Text & "'")[/B]
        da = New OleDb.OleDbDataAdapter(sql, con)
        da.Fill(ds)
        con.Close()

    End Sub

the bold is error

  • 2 Contributors
  • 1 Reply
  • 129 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by sknake
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.