How to search a keyword into multiple XML string and display all searched records in gridview

Question

0.00/5 (No votes)

See more:

i want to search a keyword(e.g item_no)and i have more than one table in a database.item_no available in many table. and i have to search in all table. wherever this is available it should be show in gridview.
My problem is: meeting records binds with gridview from 1st table only not from second table. moreover when records meet in 2nd table. then dataset came blank in gridview.
It will search in "part" first time then "document" and so on...
I am using xml for accessing the records and table name.

Please suggest me.

Thank you

What I have tried:

XML

<itemtypes>
  <item type="part">
    <property1>id</property1>
    <property2>Name</property2>
    <property3>keyed_name</property3>
    <property4>item_number</property4>
    <property5>Revision</property5>
    <property6>type</property6>
  
  </item>
  <item type="document">
    <property1>id</property1>
    <property2>Name</property2>
    <property3>keyed_name</property3>
    <property4>item_number</property4>
    <property5>Revision</property5>
    <property6>type</property6>
 
  </item>
</itemtypes>

C#

XmlNodeList elemList = xml.GetElementsByTagName("Item");

       for (int i = 0; i < elemList.Count; i++)
       {
           attrVal = elemList[i].Attributes["type"].Value;

           DataSet check = XmlBindInnovator();

           if (check.Tables.Count > 0)  //
           {
               continue;
           }
           else
               break;

       }



 private DataSet XmlBindInnovator()
   {
       StringBuilder sbAMLqry = new StringBuilder("");
       sbAMLqry.Append("<aml> <item type=""+ attrVal + "" action="get">");
       sbAMLqry.Append("<keyed_name>" + txtSearchBox.Text.Trim() + "</keyed_name>");
       sbAMLqry.Append("</item></aml>");

       Item result = ConnectionInnovator.inn.applyAML(sbAMLqry.ToString());
       string qryOutput = result.ToString();
       qryOutput = qryOutput.Replace("SOAP-ENV:Body", "RootResults");
       qryOutput = qryOutput.Replace(" id", " ids");



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

       StringReader srXML = new StringReader(xmlResult);
       ds.Reset();
       ds.ReadXml(srXML);
       GridView1.DataSource = ds;
       GridView1.DataBind();

       return ds;
   }

Posted 16-May-16 4:08am

Member 10543687

Updated 17-May-16 2:14am

George Jonsson

v2

Add a Solution

Comments

Maciej Los 16-May-16 12:54pm

Have you tried to use Linq? For example:

var result = xdoc.Descendants("item")
			.SelectMany(x=>x.Descendants())
			.Where(x=>x.Value == "item_number");

2 solutions

Solution 2

I got the solution for above issue.

C#

private void selectedColumn()
    {      
        ds = null;
        GridView1.DataSource = ds;
        GridView1.DataBind();
        XmlDocument xml = new XmlDocument();
        // You'll need to put the correct path to your xml file here
        xml.Load(ConnectionInnovator.arasCol);

        elemList = xml.GetElementsByTagName("Item");
       
        for (i = 0; i < elemList.Count; i++)
        {
            attrVal = elemList[i].Attributes["type"].Value;
            XmlBindInnovator();
            
        }
    }


    private void XmlBindInnovator()
    {
        StringBuilder sbAMLqry = new StringBuilder("");                     
        sbAMLqry.Append("<AML> <Item type = '" + attrVal + "' action = 'get'>");
        sbAMLqry.Append("<keyed_name>" + txtSearchBox.Text.Trim() + "</keyed_name>");
        sbAMLqry.Append("</Item></AML>");

        Item result = ConnectionInnovator.inn.applyAML(sbAMLqry.ToString());
        string qryOutput = result.ToString();

        if (qryOutput.Contains("<faultcode>0</faultcode>"))
        {
         
        }
        else
        {
            qryOutput = qryOutput.Replace("SOAP-ENV:Body", "RootResults");
            qryOutput = qryOutput.Replace(" id", " ids");

            XDocument xDocc = XDocument.Parse(qryOutput);
            xmlResult = xDocc.Descendants("RootResults").DescendantNodes().First().ToString();
            
            StringReader srXML = new StringReader(xmlResult);
            ds.Reset();
            ds.ReadXml(srXML);           
            GridView1.DataSource = ds;
            GridView1.DataBind();
        } 
    }

Posted 17-May-16 2:14am

Member 10543687

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)

Member 10543687 · Accepted Answer · 2016-05-17T02:12:00