Updating rows in datatable tannymaxsexy dating legs hot energy
Is there an easy way to retrieve the row count from the data Table or any of the other components?
Have you considered passing a Data Table as a parameter to this method instead of the entire dataset?
buts its too there any way to update all the rows in single. for instance, the following (over 10k rows) takes 35ms to insert 10k rows, and 35ms to update 10k rows...
foreach(datarow dr in dt.rows) instead of using for loop can i update hole column in single time. if you are confident of the new values, you might also turn off constraint checking while updating (Data Set.
My code goes below protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) it means when you click Edit button it populate item. Text; But you have to write the update method by passing the values; Hope it helps Thanks Thanks Aj Ptl for the help.. protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) Thanks Aj Ptl for the help..
now you have to update that records in DB In this case I'd write Item Command handler event and use update query on this event.
Give this a try and let us know if you run into any problems.
I have noticed that once in a while, apparently randomly, it'll go through the entire 400,000 rows in a matter of seconds. I'm wondering if it is something to do with rebuilding references, or something else..I want to find a way to recreate that.
Thanks, Simran Well, looking at the code you provided, it all seems very basic, nothing i can see would cause a slow down. Well, looking at the code you provided, it all seems very basic, nothing i can see would cause a slow down.
Is it possible to re-render all rows in a datatable without re-rendering the whole table?
Updating a cell or a whole without reloading the page of the table itself using AJAX is not that hard.