How to read xml column data of a sql server database and display in a gridview and insert data to that table from gridview only

See more:

C#

ASP.NET

How to read xml column data of a sql server database and display in a gridview and insert data to that table from gridview only ..

my database table

CREATE TABLE AllowanceDetail
(
 empkey int (foreign key)
 effectivedate date,
 allowancededuction xml
)

example of one record. this is what the format i have
EmployeeKey:-1003

EffectiveDate:-

2015-04-06 15:59:26.760	

EmpAllowanceDeduction:-

<AllowanceDeduction>
  <Allowance Name="extraactivity" Amount="50" />
  <Deducation Name="lop" Amount="-30" />
</AllowanceDeduction>