Why can't my insertcommand get parameters automatically

lawrencearab

RT
It can be found in the breakpoint that the insertcommand has been generated, but the parameters cannot be obtained.The code is as follows:
                    
OleDbDataAdapter jyda = new OleDbDataAdapter ();
                    jyda.SelectCommand = new OleDbCommand ("SELECT ID, transaction time, transaction type, transaction type, game, server, account, password, PIN, character name, payment method, transaction amount, payment status, training status, trader, Trading platform, communication software, communication software ID, telephone, task time, completion time, details FROM JYDJL ", conn);

                    OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder (jyda);
                    jyda.InsertCommand = commandBuilder.GetInsertCommand ();
                    jyda.Fill (managerDataSet, "JYDJL");

                    DataRow itemrow = managerDataSet.JYDJL.NewRow ();
                    // DataRow itemrow = serDataSet.servicingreportinfo.NewRow ();
                    itemrow ["Transaction time"] = dateTimePicker1.Value;
                    itemrow ["Transaction Type"] = comboBox1.Text.ToString (). Trim ();
                    itemrow ["Transaction Kind"] = comboBox2.Text.ToString (). Trim ();
                    itemrow ["Game"] = comboBox3.Text.ToString (). Trim ();
                    itemrow ["District service"] = textBox4.Text.ToString (). Trim ();
                    itemrow ["Account"] = textBox5.Text.ToString (). Trim ();
                    itemrow ["PIN"] = textBox6.Text.ToString (). Trim ();
                    itemrow ["Person Name"] = textBox7.Text.ToString (). Trim ();
                    itemrow ["Payment Method"] = comboBox4.Text.ToString (). Trim ();
                    itemrow ["Transaction Amount"] = d;
                    itemrow ["Payment Status"] = comboBox5.Text.ToString (). Trim ();
                    itemrow ["generation status"] = comboBox6.Text.ToString (). Trim ();
                    itemrow ["Trader"] = textBox9.Text.ToString (). Trim ();
                    itemrow ["Trading Platform"] = comboBox7.Text.ToString (). Trim ();
                    itemrow ["Communication Software"] = comboBox8.Text.ToString (). Trim ();
                    itemrow ["Communication Software ID"] = textBox10.Text.ToString (). Trim ();
                    itemrow ["Phone"] = textBox11.Text.ToString (). Trim ();
                    if (textBox12.Text.Trim ()! = "")
                    {
                        itemrow ["Task Time"] = dateTimePicker2.Value;
                    }
                    if (textBox13.Text.Trim ()! = "")
                    {
                        itemrow ["Completion time"] = dateTimePicker3.Value;
                    }
                    itemrow ["Detailed Description"] = richTextBox1.Text.ToString (). Trim ();
                    jyda.Update (managerDataSet, "JYDJL");

lawrencearab

Please give me a lot of advice

614310

jyda.InsertCommand = commandBuilder.GetInsertCommand (); This sentence is redundant. Take a look

614310

Also I didn't see you Add (itemrow), I think it took me ???

lawrencearab

After debugging, I found that the parameters in the tableadapter were obtained, and I tried using TRY. I wanted to catch the exception, and the result was no exception. But I couldn't add the data to the database.

lawrencearab

There is a repost of add (itemrow):
DataRow itemrow = managerDataSet.JYDJL.NewRow ();
                    itemrow ["Transaction time"] = dateTimePicker1.Value;
                    itemrow ["Transaction Type"] = comboBox1.Text.ToString (). Trim ();
                    itemrow ["Transaction Kind"] = comboBox2.Text.ToString (). Trim ();
                    itemrow ["Game"] = comboBox3.Text.ToString (). Trim ();
                    itemrow ["District service"] = textBox4.Text.ToString (). Trim ();
                    itemrow ["Account"] = textBox5.Text.ToString (). Trim ();
                    itemrow ["PIN"] = textBox6.Text.ToString (). Trim ();
                    itemrow ["Person Name"] = textBox7.Text.ToString (). Trim ();
                    itemrow ["Payment Method"] = comboBox4.Text.ToString (). Trim ();
                    itemrow ["Transaction Amount"] = d;
                    itemrow ["Payment Status"] = comboBox5.Text.ToString (). Trim ();
                    itemrow ["generation status"] = comboBox6.Text.ToString (). Trim ();
                    itemrow ["Trader"] = textBox9.Text.ToString (). Trim ();
                    itemrow ["Trading Platform"] = comboBox7.Text.ToString (). Trim ();
                    itemrow ["Communication Software"] = comboBox8.Text.ToString (). Trim ();
                    itemrow ["Communication Software ID"] = textBox10.Text.ToString (). Trim ();
                    itemrow ["Phone"] = textBox11.Text.ToString (). Trim ();
                    if (textBox12.Text.Trim ()! = "")
                    {
                        itemrow ["Task Time"] = dateTimePicker2.Value;
                    }
                    if (textBox13.Text.Trim ()! = "")
                    {
                        itemrow ["Completion time"] = dateTimePicker3.Value;
                    }
                    itemrow ["Detailed Description"] = richTextBox1.Text.ToString (). Trim ();
                    managerDataSet.JYDJL.Rows.Add (itemrow);
                    jYDJLBindingSource.EndEdit ();
                    try
                    {
                        jYDJLTableAdapter.Update (managerDataSet.JYDJL);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show ("Add failed! Reason for failure:" + ex.Message, "Hint", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }

614310

CommandBuilder must index the data source to be updated. Is your table index self-incrementing or manually specified?

In addition jyda.Fill (managerDataSet, "JYDJL"); Has the index been filled in?

Track the tables in the dataset to see if the index of this itemrow is correct after Add (itemrow)

614310

dataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
Then execute Fill to fill the constraints of the source table into the dataset

lawrencearab

I set my ID column to auto-increment

lawrencearab

But when I do the insertion, the ID column is not inserted in the insertcommand name. I don't think it will affect it.