how to make select statements on xml file

Question

0.00/5 (No votes)

See more:

Hi All,

i have a grid view with displaying xml file data. i want to perform filter on gridview using dropdown box .
ex:
i have name ,city,location in xml data
in dropdown i had location
when dropdown change event occures i want to display particular location details on gridview.

my prob is i don't know how to select perticular element value from xml to comapre.
i am very new to xml database.

Posted 28-May-12 19:41pm

jvamsikrishna

Add a Solution

Comments

jvamsikrishna 30-May-12 0:58am

I had achieved to reslove my problem using this code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Xml.Linq;
using System.Drawing;
using System.Data;

public partial class GridViewFilter : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
XmlTextReader xtr = new XmlTextReader(Server.MapPath("~/xml/xmltest.xml"));
DataSet ds = new DataSet();
ds.ReadXml(xtr);

GridView1.DataSource = ds;
GridView1.DataBind();
getxml();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "name";
DropDownList1.DataValueField = "name";
DropDownList1.DataBind();

DropDownList2.DataSource = ds;
DropDownList2.DataTextField =ds.Tables[0].Columns[3].ToString();
DropDownList2.DataValueField = "location";
DropDownList2.DataBind();
}
protected void getxml()
{
XmlTextReader xtr = new XmlTextReader(Server.MapPath("~/xml/xmltest.xml"));
DataSet ds = new DataSet();
ds.ReadXml(xtr);

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

}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string name= DropDownList1.SelectedItem.Text;
DataTable dt = new DataTable();
dt.Columns.Add("fname", typeof(string));
dt.Columns.Add("lname", typeof(string));
dt.Columns.Add("name", typeof(string));
dt.Columns.Add("location", typeof(string));
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(Server.MapPath("~/xml/xmltest.xml"));
XmlNodeList nodeList = xmldoc.SelectNodes("/karomi/emp");

foreach (XmlNode node in nodeList)
{
if (name== node["name"].InnerText)
{
DataRow dtrow = dt.NewRow();
dtrow["fname"] = node["fname"].InnerText;
dtrow["lname"] = node["lname"].InnerText;
dtrow["name"] = node["name"].InnerText;
dtrow["location"] = node["location"].InnerText;
dt.Rows.Add(dtrow);
}
}

GridView1.DataSource = dt;
GridView1.DataBind();

}
}

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)

Rahul Rajat Singh · Accepted Answer · 2012-05-28T19:44:00

Solution 1

1. Read the XML into a Dataset
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/67dacbbf-6358-4de7-b398-293e89cab6b1/[^]

2. use query on dataset
http://social.msdn.microsoft.com/Forums/lv/adodotnetdataset/thread/23fb3bf1-a6f5-446a-8ffa-564a78509d06[^]

http://stackoverflow.com/questions/6001086/querying-a-datatable-using-linq[^]

Posted 28-May-12 19:44pm

Rahul Rajat Singh

Comments

Prasad_Kulkarni 29-May-12 7:23am

5'ed

jvamsikrishna 30-May-12 0:54am

Thanks for you help to reslove my query

Rahul Rajat Singh 30-May-12 0:59am

you are most welcome. always happy to help.

Prosan · Accepted Answer · 2012-05-28T20:55:00

i give you links i hope it will give you brief idea of xml and solve your query

XML for beginners and experts[^]

best of luck

i am give you simple example i think it will more help you

C#

using System.IO;
using System.Xml;
private void readDatafromXML(string file_Path)
    {
        DataSet DS_purchase;
int timeout = Server.ScriptTimeout;
        Server.ScriptTimeout = int.MaxValue;
        FileInfo FInfo = new FileInfo(file_Path);
        if (FInfo.Exists)
        {
            XmlTextReader xmlReader;
            xmlReader = new XmlTextReader(FInfo.FullName);
            try
            {
                DS_purchase.ReadXml(xmlReader);
                xmlReader.Close();               
            }
            catch (Exception ex)
            {
                xmlReader.Close();
                lbl_err.Text = "Error in Reading XML file " + ex.Message;
            }

            finally
            {
                xmlReader.Close();

            }
        }
        else
            lbl_err.Text = "Session Has been expired.please Try again. ";

// on this dataset you can create your query 
    }