Avatar of nitinpaul
nitinpaul

asked on 

Problems with the data adapter update "Syntax error in INSERT INTO statement."

I am getting error "Syntax error in INSERT INTO statement." in the "dadaptor.Update(objDatatable)"

i am not using any SQL command here.....
but i am getting this prob
Public conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data.mdb;")
Public dadaptor As New OleDbDataAdapter("SELECT * FROM church_members", conn)
Public objDatatable As New Data.DataTable(table)
 
Dim dt As Data.DataRow = objDatatable.NewRow()
 
 
            With dt
                'Personal Info
                .Item(field.member_name) = txtname.Text
                .Item(field.father_name) = txrfathersname.Text
                .Item(field.mother_name) = txtmothersname.Text
                .Item(field.dateofbirth) = dob.Value
                .Item(field.photo) = ""
                If rdomale.Checked Then
                    .Item(field.sex) = "M"
                Else
                    .Item(field.sex) = "F"
                End If
End With
 
 
            objDatatable.Rows.Add(dt)
            ' objDatatable.AcceptChanges()
 
            conn.Open()
            Dim dbcommand As New OleDbCommandBuilder(dadaptor)
            
		dadaptor.Update(objDatatable)
 
            conn.Close()

Open in new window

.NET ProgrammingVisual Basic.NET

Avatar of undefined
Last Comment
Wayne Taylor (webtubbs)

8/22/2022 - Mon