Thursday, October 15, 2009 4:09 AMHi
I am working in VB.Net CF (Pocket Pc application) , In our application we have dataset of appr. 2000 records and 20 columns in it
Based on functionality I have to clear the values in some of the columns for all the rows
At present we are looping through the records in dataset and clearing the values , this logic almost takes about 3 mins to complete
Can anyone tell a better logic to implement the above functionality, so that looping the records in dataset can be avoided and performance can be improved
OrIS there any coding to clear values of all the rows in dataset for a particular column
- Moved by Max Wang_Chinasoft Tuesday, April 19, 2011 10:44 PM Forum consolidation (From:SyncFx - Technical Discussion [ReadOnly])
Monday, December 28, 2009 6:30 PM
This issue does not seem related to Microsoft Sync Framework, so you may want to find a better forum for your query.
Not knowing much about your requirements and assuming you are using a database underneath your VB client, you can consider writing a stored procedure that clears "some columns for all the rows" and invoke the stored procedure from VB client as desired. See if this helps.