none
Update requires a valid InsertCommand when passed DataRow collection with new Rows??

    Question

  • I'm still pretty new at .Net and database coding, and am working on a small program that is generating an error and I'm not sure how to resolve it.

    My code:

     

    Public Class MainForm
    
    
        Private m_cn As New SqlConnection()
        Private m_DA As SqlDataAdapter
        Private m_CB As SqlCommandBuilder
        Private m_DataTable As New DataTable
        Private m_rowPosition As Integer = 0
    
    
    
    
        Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            m_cn.ConnectionString = "Data Source=.\SQLEXPRESS; AttachDbFilename = C:\Temp\Test.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            m_cn.Open()
    
            m_DA = New SqlDataAdapter("Select * from Contacts", m_cn)
            m_DA.Fill(m_DataTable)
    
            Me.ShowCurrentRecord()
        End Sub
    
    
    
        Private Sub btnAddNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddNew.Click
            Dim drNewRow As DataRow = m_DataTable.NewRow()
    
            drNewRow("ContactName") = txtNewContactName.Text
            drNewRow("State") = txtNewState.Text
            m_DataTable.Rows.Add(drNewRow)
    
    
            m_DA.Update(m_DataTable)
            m_rowPosition = m_DataTable.Rows.Count - 1
            Me.ShowCurrentRecord()
        End Sub
    
    End Class
    
    

     

    I'm getting the error:  "Update requires a valid InsertCommand when passed DataRow collection with new Rows"

    At the following statement: m_DA.Update(m_DataTable)

     

    I can't for the life of me figure this out.  I know the answer is going to be very simple, but I'm at a loss.  I would greatly appreciate it if someone could point out the flaw in my code and how to correct it.  And yes, I have done fairly extensive searching on this error, but none of them give any idea how to fix it, they just hint around at what's wrong. 

     

    Thanks!

     

     

     

     

     


    • Edited by ms960 Tuesday, October 18, 2011 1:36 AM Typo
    Tuesday, October 18, 2011 1:34 AM

Answers

All replies