How to save datagridview columns with datas in sql server database

Scenario is.... I have to select a row in datagridview and sa开发者_如何学运维ve those datas to database.It can any number of columns present. how to achieve this..

---

Good way to achieve this is to create XML string of all modified rows.

Than pass this string to Stored procedure.

In stored procedure use OpenXML which allow you to update multiple rows easily.