tableadapter.update (ds.table) fails, why

lawrencearab

Looking through the breakpoint, it was found that ds.table.rows.add (row) was successful, and the data was added to ds.table. Then, after tableadapter.update (ds.table), check the properties of the tableadapter. The adapter's insertcommand is : INSERT INTO `JYDJL` (` time`, `type`,` kind`, `game`,` community service`, `account`,` password`, `PIN`,` character name`, `method`,` ` Communication software`, `Communication software ID`,` Phone`, `Details`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ).

Later check, the data of each field in the parameters in the insertcommand in the adapter of the adaptable adapter was obtained. After the added action was completed, the data was added to the DATAGERIDVIEW bound to DATASET.TABLE, but later found that the The authenticity is written into the database, why is it so?

614310

No error prompt? Did you catch it?

lawrencearab

try
                    {
                        jYDJLTableAdapter.Update (managerDataSet.JYDJL);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show ("Add failed! Reason for failure:" + ex.Message, "Hint", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }

No errors are suggested

lawrencearab

I also tried the method of using tableadapter.insert, but I still can't load the data into the database and can only update it in DATASET.

lawrencearab

Which one would help me a lot ~ How to update the database in the dataset

windsonleo

I also encountered this problem. . . . Urgent

hurryhong

If the primary key or unique column is included, if the table does not contain a relationship, then use the automatic generation command, and only need Adapter.Update() when saving.