Guest User

Untitled

a guest
Aug 24th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.27 KB | None | 0 0
  1. populate LINQ to XML to Grdiview
  2. <?xml version="1.0" ?>
  3. - <!-- Created @ 9/14/2011 1:16:52 PM
  4. -->
  5. - <DoctorList>
  6. - <Doctor ID="1" Specialist="Dentist">
  7. <Username>Ahmed</Username>
  8. <Password>12345</Password>
  9. </Doctor>
  10. - <Doctor ID="2" Specialist="oculist">
  11. <Username>Aya</Username>
  12. <Password>12345</Password>
  13. </Doctor>
  14. - <Doctor ID="3" Specialist="surgery">
  15. <Username>malak</Username>
  16. <Password>12345</Password>
  17. </Doctor>
  18. </DoctorList>
  19.  
  20. IEnumerable<XElement> matches = from Doctor in doc.Descendants("Doctor") where (int)Doctor.Attribute("ID") > 1 select Doctor;
  21. GridView1.DataSource= matches;
  22. GridView1.DataBind();
  23.  
  24. <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
  25. CellPadding="4" HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White"
  26. HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True"
  27. ondatabound="GridView1_DataBound">
  28. <Columns>
  29. <asp:BoundField HeaderText="Specialist" DataField="Specialist" />
  30. <asp:BoundField HeaderText="ID" DataField="ID" ItemStyle-HorizontalAlign="Right" />
  31. <asp:BoundField HeaderText="Username" DataField="Username" ItemStyle-HorizontalAlign="Right" />
  32. <asp:BoundField HeaderText="Password" DataField="Password" ItemStyle-HorizontalAlign="Right" />
  33. </Columns>
  34.  
  35. <HeaderStyle HorizontalAlign="Center" BackColor="Blue" Font-Bold="True" ForeColor="White"></HeaderStyle>
  36. </asp:GridView>
  37.  
  38. IEnumerable<XElement> matches =
  39. from Doctor in doc.Descendants("Doctor")
  40. where (int)Doctor.Attribute("ID") > 1
  41. select new {
  42. Specialist = Doctor.Attribute("Specialist").Value,
  43. ID = Doctor.Attribute("ID").Value,
  44. Username = Doctor.Element("Username").Value,
  45. Password = Doctor.Element("Password").Value
  46. };
  47.  
  48. GridView1.DataSource = matches;
  49. GridView1.DataBind();
  50.  
  51. <DoctorList>
  52. <Doctor ID="1" Specialist="Dentist" UserName="Ahmed" Password="12345" />
  53. <Doctor ID="2" Specialist="oculist" Username="Aya" Password="12345" />
  54. <Doctor ID="3" Specialist="surgery" Username="malak" Password="12345" />
  55. </DoctorList>
Add Comment
Please, Sign In to add comment