CODEWITHSUNDEEP
linqvisual-studio-2008visual-studio-2010linq-to-sql
Hoorayo
Hoorayo

Reputation: 615

How to save multiple rows on data grid

Let's say I have ten rows on a data grid and I have changed data of three rows.

I am trying to save data by Linq for those three rows, but I am not sure how it is possible to save them.

I can do it by looping whole rows by checking each row for any change.

Is there any smarter way to save multiple data rather than looping by code, such as For Next.

Upvotes: 1

Views: 344

Answers (1)

Jim Wooley
Jim Wooley

Reputation: 10408

As long as the Data Context is kept alive while the changes are made in the grid, you can save all of the changes by calling SubmitChanges() using the Unit of Work pattern. This works fine in stateful (Winform/WPF) implementations. In web applications, the typical UI models only allow for editing a single row per page submission. In that case, the challenge becomes how to allow editing multiple records in a single page request. If you can do that, then you can batch up your updates and only call SubmitChanges once per page request.

Upvotes: 1

Related Questions