Bind XML to Grid view in asp.net

Question

0.00/5 (No votes)

See more:

Hello Techies

I brought the sharepoint document library into asp.net application, From that i want to show the version history of a particular file
If i select the particular file means i get the version history using versions webservice, I got the version history as a XML format. now i want it to bind in Grid.

The XML Is below

<list id="{918044DD-4034-4804-862D-91DA49D93299}" xmlns="http://schemas.microsoft.com/sharepoint/soap/" />
<versioning enabled="1" xmlns="http://schemas.microsoft.com/sharepoint/soap/" />
<settings url="http://admin:10085/_layouts/LstSetng.aspx?List={918044DD-4034-4804-862D-91DA49D93299}" xmlns="http://schemas.microsoft.com/sharepoint/soap/" />
<result version="@2.2" url="http://admin:10085/DocumentLibrary/New Text Document (2).txt" created="11/10/2011 3:31 PM" createdBy="ADMIN\administrator" size="25" comments="xcvbxc" xmlns="http://schemas.microsoft.com/sharepoint/soap/" />
<result version="1.0" url="http://admin:10085/_vti_history/512/DocumentLibrary/New Text Document (2).txt" created="11/9/2011 7:54 PM" createdBy="ADMIN\administrator" size="25" comments="" xmlns="http://schemas.microsoft.com/sharepoint/soap/" />
<result version="2.1" url="http://admin:10085/_vti_history/1025/DocumentLibrary/New Text Document (2).txt" created="11/10/2011 3:31 PM" createdBy="ADMIN\administrator" size="25" comments="" xmlns="http://schemas.microsoft.com/sharepoint/soap/" />

Please help me to sort out this problem....

Posted 11-Nov-11 1:50am

sathish.kasin

Updated 11-Nov-11 1:56am

v3

Add a Solution

3 solutions

Solution 1

You have to Convert the Xml data to DataTable first and bind that DataTable object to GrideView;

C#

DataTable dt = new DataTable();
dt.ReadXml(@"filepath.xml");
GridView1.DataSource = dt;
GridView1.DataBind();

Posted 11-Nov-11 3:53am

shashikanth 2011

Comments

chitmm 17-Sep-12 21:38pm

DataTable does not support schema inference from Xml!!!

Solution 2

when u right click the gridview control in the asp.net page it ll ask for the source u can also choose the xml file form there...jus try it

Posted 11-Nov-11 4:41am

resonance_siv

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sathish.kasin · Accepted Answer · 2011-11-14T00:06:00

the solution is below

Versions objVersions = new Versions();
objVersions.Url = ConfigurationManager.AppSettings["SharepointVersionService"];
objVersions.Credentials = CreateCredentials();
XmlNode Result = objVersions.GetVersions(FileName);
if ((Result != null) & Result.InnerXml.Length > 0)
{
XmlTextReader objXmlTextReader = new XmlTextReader(Result.OuterXml, XmlNodeType.Element, null);
DataSet objDataSet = new DataSet();
objDataSet.ReadXml(objXmlTextReader);
Gridhistory.DataSource = objDataSet.Tables[3].DefaultView;
Gridhistory.DataBind();

}

Bind XML to Grid view in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Bind XML to Grid view in asp.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us