Child list for field dataaGridView1 cannot be created

newdbo

Active member
Joined
Aug 23, 2009
Messages
25
Programming Experience
Beginner
Hi all,
I have an error in my application, "Child list for field GridView1 cannot be created."
VB.NET:
strSQL = "select * from GridView"

        Dim dadapter As New SqlDataAdapter(strSQL, oconnection)
        dadapter.TableMappings.Add("GridView", "GridView1")
        m_dataset = New DataSet
        dadapter.Fill(m_dataset)
        'DataGridView1.DataSource = null
        'DataGridView1.DataMember = null
        DataGridView1.DataSource = m_dataset
        DataGridView1.DataMember = "GridView1"
        DataGridView1.Columns(0).Visible = False
and this is the button to save the changes of dataset
VB.NET:
If m_dataset.HasChanges Then

            If oconnection.State = ConnectionState.Open Then
                oconnection.Close()
            End If
            sqlconnectionstring = "Integrated Security=SSPI;" + "Initial Catalog=opex;" + "Data Source=localhost;"

            oconnection.ConnectionString = sqlconnectionstring

            oconnection.Open()
            Dim daadapter As New SqlDataAdapter(strSQL, oconnection)
            daadapter.TableMappings.Add("GridView", "GridView1")
            Dim cb As New SqlCommandBuilder(daadapter)
            daadapter.Update(m_dataset)





        End If
My code is trying to view a table from database, load it to a datagridview and directly can update more than a row in datagridview to database..Any help or advise really appreciated..
 
Back
Top