Hi all,
I have an error in my application, "Child list for field GridView1 cannot be created."
and this is the button to save the changes of dataset
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..
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
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