Update Gridview data to SQL Server 2008 R2 through XML

See more:

C#

ASP.NET

SQL-Server

Hi,

I have a Gridview which has 4 columns, ID,First(Radiobutton),Second(Radiobutton) and Yes/No(Checkbox) , the sample data is as follows:

ID        First(Radiobutton)      Second(RadioButton)         Yes/No(CheckBox)

001        checked                  not checked                  checked
002        not checked               checked                   not checked
003        checked                  not checked                  checked
004        checked                  not checked                  checked

In SQL Server the table contains the columns as ID(Varchar), Priority(int) which is 1 if First RadioButton checked and 2 if Second Radio Button is checked, and Decision(true if Yes/No checkbox is checked and false id not checked), As(according to the gridview data

ID         Priority         Decision

001        1                 true
002        2                 false
003        1                 true
004        1                 true

Now, I want to update the data by clicking a 'Save' button but want tpo update the data through XML. So can anyone assist me with this?