Hi,

I'm wondering if somebody can help me. I have a VSTO 2005 VB.NET excel 2003 project that I'm trying to automate. I have Listobject in the excel project that I'm able to populate data from an SQL 2005 database with no problem. My question is the following. How do I update the database with the changes I make to the listobject I have on my excel project? I have looked at the VSTO samples but I can't get this to work. When I close and run my solution a second time, the changes that I made to the listobject previously do not get saved back to the database. Why is that?? I'm kind of new to VSTO so I'm not sure how to go about this.

Any help anyone can provide will be greatly appreciated.

You need to commit the changes that are in the memory instance of the dataTable back to the database. Use the Update method on the tableAdapter that is created for you to do this. e.g., if you had the northwind data set's customers table bound to the listObject, you would update the database with the following code:

this.customersTableAdapter.Update ( this.northwindDataSet.Customers );

Thanks.

Yes you are correct. I'm using this but the database doesn't get update. I have a Listobject on Sheet1 that gets populated with the dataset correctly with the corresponding table. Here's the code snippets from the project.

Private Sub Sheet1_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup

If Me.NeedsFill("NorthwndDataSet") Then

Me.EmployeesTableAdapter.Fill(Me.NorthwndDataSet.Employees)

End If

Me.Button1.Text = "Save"

End Sub

- Here's what I do. 1. Run the project. 2. Make changes to some of the fields of the listobject. 3. Click Button1 to save changes. 4. Close the project. 5. Open the project again. 6. Changes I made were not saved.

Any ideas?? I'm using VS2005, Office 2003.

Please make sure that the update command on the table adapter has actually been configured and initialized. In the default data sources wizard, only the select command is created on the table adapter. Look at the generated code in your source files on the table adapter to see if the update command has been set in it.

Is this a bug in the wizard? I looked at the generated code and it looks like the update command has been configured and initialized correctly. Not sure what part of the generated code is causing this problem? Can you post a code snippet of what additional generated code should be added and where it should be pasted to the update command of the adapter? There's too much generated code and therefore I'm not sure what's missing.

BTW - This is the example from the Visual Studio 2005 Excel Walkthroughs "Binding Cells to Multiple Columns in a Table".

Thanks for you help..