Quick way to insert the same record as copy using Tableadapter

Question

I have a datatable with a bunch of fields, and it's filled data by tableadapter. Usually, records that need to be inserted are a little bit different (only id). I don't want user to retypes everything again so, is there a quick way to insert current record into database. Notice that all my insert, update and delete operations are based on my tableadapter.

//Get only one last record that has been added when the form load.
bookTableAdapter.FillByLastID(bookDataSet.dtBook);

private void btnNew_Click(object sender, EventArgs e)
{  
  bookBindingSource.AddNew();  
}

private void btnSave_Click(object sender, EventArgs e)
{
  this.Validate();
  bookBindingSource.EndEdit();
  bookTableAdapter.Update(bookDataSet.dtBook);
}

Some code example would be great. Because its not clear how you do the update work. Do u post the whole table or what? — Kemal Can Kara, Nov 29 '11 at 12:16
I just the update method on my datadapater. I post one record at a time. — sovantha, Nov 29 '11 at 12:28

Stecya · Accepted Answer · 2011-11-29T12:58:42.083

2

Try this to copy row:

        DataRow row = table.Rows[0]; // row you want to copy

        DataRow newRow = table.NewRow();
        newRow.ItemArray = row.ItemArray.ToArray();
        newRow["Id"] = 10;  // change Id

        table.Rows.Add(newRow);

edited Nov 29 '11 at 12:58

answered Nov 29 '11 at 12:25

Stecya

22,896
10
72
102

What is GUid.NewGuid();? I've got a error message: Unable to cast object of type 'System.Guid'to type 'System.IConvertable'. Couldn't store in ID Column. Expected type is Int32 – sovantha Nov 29 '11 at 12:53
In my example Id column is type of Guid, As I see you have int there so change it to some int.See my update – Stecya Nov 29 '11 at 12:58

score 0 · Answer 2 · edited May 23 '17 at 12:28

0

The accepted answer didn't work for me because the TableAdapter query returned more columns than a new row had, 33. My table has 32 columns. This is legacy code and database.

However, this article gave me the answer: This Row already belongs to another table error when trying to add rows?

edited May 23 '17 at 12:28

Community

1
1

answered May 18 '15 at 19:33

Rhyous

6,510
2
44
50

Quick way to insert the same record as copy using Tableadapter

2 Answers2