Dataset XSD does not generate code-accessible table adapters

Question

In a vb.net winforms application in VS 2022 or 2019, I create an XSD dataset and then add a table to it.

Next, I try to add data to the table, like this:

' Insert the source row into the target dataset
Dim newRow As DataRow = curvesDbDataset.AccumulatedData.NewRow()
newRow.ItemArray = sourceRow.ItemArray
newRow("workstation_name") = workstationName
curvesDbDataset.AccumulatedData.Rows.Add(newRow)

That executes without error, but no data is added to the table represented by curvesDbDataset.

The update command should look something like this:

curvesDbDataset.AccumulatedDataDataTable.Update(curvesDbDataset.AccumulatedData)

But AccumulatedDataDataTable does not exist in the object. Neither ChatGPT nor Google seem to know why.

Why can I not update the database using this method, what am I missing?

Answer 1

Hi @Jon Jaques ,

You need to use TableAdapter to update your dataset.

Check the following document to see if it helps.

Fill datasets by using TableAdapters in .NET Framework applications

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.