Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
How to avoid Looping of Dataset rows in coding?

Bloqueada How to avoid Looping of Dataset rows in coding?

  • Thursday, October 15, 2009 4:09 AM
     
     
    Sign In to Vote
    0
    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

    Or

    IS 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])
    •  
       

    All Replies

    • Monday, December 28, 2009 6:30 PM
       
       Answered
      Sign In to Vote
      0

      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.

       

      Sameer