Hi,

I am new to VSTO. I am still not getting any suitable answer for my earlier posts. Let me expalin my actual problem:

I have used following code to bind the ListObject:

DataSet dsTrims = new DataSet();

dsTrims = MyDataAccessLayer.Provider.ExecuteDataSet(System.Data.CommandType.Text, strWhere);

this.bindingdataSource1.DataSource = dsTrims.Tables[0];

myListObject.AutoSetDataBoundColumnHeaders = true;

Hey,

One way I can think of is to monitor ListObject change event and get the target range that has content changed, then update the data directly using sql commands.

Hope this helps,

Mei

--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

The "Binding Data to Controls Overview" article from our VSTO On-line Help Documentation in the MSDN Library may help you here. Here is the link to the article:

http://msdn2.microsoft.com/en-us/library/ad7sfx3w(VS.80).aspx

There is a section on updating data that may be useful to you. Please review this article, apply your newfound knowledge to your scenario, and let us know if you have any further questions.

Thanks!

Mike Hernandez
Community Program Manager
VSTO Team

Hi,

Thanks you both for your reply.

1. Mei Liang Said:

"One way I can think of is to monitor ListObject change event and get the target range that has content changed, then update the data directly using sql commands."

My Post:

"How should I grab target range that has content changed. And suppose user has changed more than 10 ranges/cells, then where should I collect all these changes. In List Collection? Can we iterate through ListObjects columns and rows and put these changes to any collection? Please provide some code for better understanding."

2. Mike Hernandez Said:

" The "Binding Data to Controls Overview" article from our VSTO On-line Help Documentation in the MSDN Library may help you here. Here is the link to the article: http://msdn2.microsoft.com/en-us/library/ad7sfx3w(VS.80).aspx

There is a section on updating data that may be useful to you. Please review this article"

My Post:

"I went through this article and found the topic for updating data but its not useful and suitable for me because its uses TableAdapter everywhere for updating. In my case as above code shown, I think we cannt use TableAdapter here."

3. Is it possible to update just single table without TableAdapter with ListObject. Suppose in my case I am using just one table instead of 3-4 tables and then my strWhere="Select * from Table1". Is there possibility after that?

4. Can we collect all the changes made to cells/range of listbox/excelsheet by iterating through listbox into list collection and then can we force this list collection to update. Can data into list collection automatically mapped to specific tables column name. If possible please provide some example code.

Thank you

Hi,

Please provide some usefull feedback.

Thank you

Your questions deal with some of the details of the data binding architecture in Winforms. I would suggest you check up the details of DataSets and how the update can go forward to the actual table at http://msdn2.microsoft.com/en-us/library/system.data.dataset(VS.80).aspx.

Some of the steps in working with DataSets include:

Hi Nikhil,

Its very nice post but not going to help me lot.

Beacuse I have already told that I am unable to use "DataAdapter" here.

Please provide some other solution.

Thank you

As I suggested, your question seems to deal with ADO.NET architecture. I would suggest you to check up http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.dotnet.framework.adonet&lang=en&cr=US or http://forums.microsoft.com/msdn/showforum.aspx?forumid=45&siteid=1.