How do I make XML string as a datasource for gridview in ASP.NET

Question

0.00/5 (No votes)

See more:

I have xml in string variable. how can i make this string as a datasource for gridview

Please guide me.

What I have tried:

Save in to xml file but not able to read.

Posted 11-May-16 22:48pm

Member 10543687

Updated 13-May-16 4:02am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Kunwar Bahadur Singh · Accepted Answer · 2016-05-12T01:22:00

C#

You can use below code to convert xmlstring to Datset and then bind the gridView.

You can use a StringReader to load it into a DataSet. From there, the table with the first index will contain the DataTable.

public DataTable stam()    
{
    StringReader theReader = new StringReader(xmlDataString);
    DataSet theDataSet = new DataSet();
    theDataSet.ReadXml(theReader);

    return theDataSet.Tables[0];
}

Above code will work fine if your XMlString is valid XMLString.

Member 10543687 · Accepted Answer · 2016-05-13T04:02:00

Here i'm creating xml into file. it'll create by code and check availability of the file if exist it will delete old contain of the xml file and saves the new xml into this.

C#

string createXMLpath = @"C:\\Temp\\myXMLfile.xml";

C#

string xmlResult = xDocc.Descendants("RootResults").DescendantNodes().First().ToString();

C#

if (!File.Exists(createXMLpath))
          {
              File.Create(createXMLpath).Close();
              File.WriteAllText(createXMLpath, xmlResult);
          }
           else if (File.Exists(createXMLpath))
          {
              File.WriteAllText(createXMLpath, String.Empty);
              using (StreamWriter sw = new StreamWriter(createXMLpath, true))
              {
                  sw.WriteLine(xmlResult);
                  sw.Close();
              }
          }

C#

ds.ReadXml(xmlResult);
       GridView1.DataSource = ds;
       GridView1.DataBind();

How do I make XML string as a datasource for gridview in ASP.NET

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0