c# - Insert method of TableAdapter not working?

Question

I'm using ADO.NET in my C# project. In my form I added a SourceBinding element from my toolbox in VS2010. I set the connection to the table of my dataset. It creates a DataAdapter automaticly for my.

I want to insert a record, so I call the Insert() method of the DataAdapter. But when I view my database data, it doesn't have any new records...

orderID = this.orderTableAdapter.Insert("", "", 
                (int)OrderStatus.IN_CONSTRUCTION, DateTime.Now);

Or do I need to insert it manually with the SqlCommand???

Answer 1

I too was having difficulty figuring this out.

You need to call DataSet.AcceptChanges() after the TableAdapter.Insert(...)

That worked for me.

So the steps are:

1. Create your bindingsource, tableadapter and dataset using visual studio.
2. TableAdapter.Fill(..) // this should automatically be added by vs.
3. TableAdapter.Insert(..)
4. DataSet.AcceptChanges()
5. TableAdapter.Update(..)