Add new Rows

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • al fart
    New Member
    • Jul 2015
    • 2

    Add new Rows

    Code:
    Dim conn As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; data source = " & msPath & "Database1.accdb;")
    Dim dt As New DataTable()
    Dim sSql As String = "SELECT * FROM Table1"
    Dim da As New OleDb.OleDbDataAdapter(sSql, conn)
    Dim iChange As Integer
    da.Fill(dt)
    For iLoop As Integer = 0 To lstN.Count - 1
    	Dim row As DataRow = dt.NewRow
    	row("Draw") = lstN.Item(iLoop)
    	row("Character") = lstC(iLoop)
    	dt.Rows.Add(row)
    Next
    
    'Here is the Question:
    'An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
    
    iChange = da.Update(dt)
    
    'Syntax error in INSERT INTO statement
    
    conn.Close()
    thanks for help
    Last edited by Rabbit; Jul 13 '15, 03:37 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
Working...