How to avoid Looping of Dataset rows in coding? RRS feed

  • Question

  • Hi

    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


    IS there any coding to clear values of all the rows in dataset for a particular column
    • Moved by Max Wang_1983 Tuesday, April 19, 2011 10:44 PM Forum consolidation (From:SyncFx - Technical Discussion [ReadOnly])
    Thursday, October 15, 2009 4:09 AM


  • Hi Shobha,

    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.



    Monday, December 28, 2009 6:30 PM