Updating a row in datatable

As of now, the application runs perfectly and does exactly what I need it to, but the problem comes in when a large data set is reviewed.If I am pulling records for one day or even maybe a week, it runs at a decent pace, but once you get a month of data or more, it takes a fairly long amount of time. Is there possibly a better way that I can code this?This generation logic requires key column information to be present in the Data Set.For more information see Generating Commands with Command Builders.I think this is enough code to make sense of what I'm doing, but if more is needed just let me know and I can post it up as well.in the inner loop after a match is found - but reverting the order of the 2 loops) - but leaving the complexity order to O(n^2).

Source Column refers to the unmapped column name before any table mappings have been applied.After a row updates successfully, the changes to that row are accepted.When using Update, the order of execution is as follows: Each command associated with the Db Data Adapter usually has a parameters collection associated with it.If Source Column refers to a nonexistent column, the action taken depends on one of the following Missing Mapping Action values.The Source Column property is also used to map the value for output or input/output parameters back to the Data Set.

Leave a Reply