reading two or more xml filesusing xml document

Question

Hi I have done a program such that it reads a xml schema and gets data from a input xml file and loads into a particular column, the values (for the existence of same field) in a new xml file. other fields are loaded with values automatically. Now I have to read one more xml file(another input xml file along with the first one and load into anoyther column fo rthe existence of that field) I have done for reading one xml file. How to read two or more at the same time. Here is my that part of the coding. please help me to do this. In the coding I have marked **************** in the middle, that is the part wher I have to read the input xml . so I need to read two or more files there. What shall I do. please help me to do that private void button2_Click(object sender, System.EventArgs e) { ArrayList FiledNames = new ArrayList(); XmlDocument xdc = new XmlDocument(); //Read the file which contain the field names xdc.Load(@"C:\CDEV	estdatagenerator\Field Names.xml"); XmlNodeList nodFields = xdc.DocumentElement.SelectNodes("//item"); for(int i=0; i<nodFields.Count;i++) FiledNames.Add(nodFields.Item(i).InnerXml); ArrayList MatchList = new ArrayList(); //Read the schema file dataSet1.ReadXmlSchema(txtSchema.Text); foreach (DataTable dTbl in dataSet1.Tables) { int i = 0; foreach (DataColumn dColmn in dTbl.Columns) { for (int y=0; y < FiledNames.Count; y++) { if(dColmn.ColumnName.ToString() == FiledNames[y].ToString()) { MatchList.Add(new FieldList(i, FiledNames[y].ToString())); break; } } i++; } } / //Load the data file *********************** ******************************************************** xdc.Load(txtData.Text); foreach (DataTable dTbl in dataSet1.Tables) { object[] oValues = new object[dTbl.Columns.Count]; String sXPath = "//" + dTbl.TableName.ToString(); XmlNodeList nodeRows = xdc.SelectNodes(sXPath); for(int i = 0; i <= 200; i++) { int k=0; foreach (DataColumn dColmn in dTbl.Columns) { bool bFound = false; foreach(FieldList FL in MatchList) { if(dColmn.ColumnName.ToString() == FL.ColDesc.ToString() && i<nodeRows.Count) { String xPath = dColmn.ColumnName.ToString(); XmlNode node; node = nodeRows.Item(i).SelectSingleNode(xPath); if(node != null) { oValues[k] = node.InnerText; bFound = true; break; } } } if(!bFound) { switch(dColmn.DataType.ToString()) { case "System.String": oValues[k] = (string) "castle Hampers" + i; break; case "System.Int32": oValues[k] = (int) 66 + i; break; case "System.DateTime": oValues[k] = new DateTime(2004,01,30).AddDays(i * 1); break; case "System.Decimal": oValues[k] = new Decimal(1900.20) + i; break; case "System.Int16": oValues[k] = (short) 3256 + i; break; case "System.Int64": oValues[k] = (long) 400 + i; break; case "System.Double": oValues[k] = (double) 8888 - i; break; case "System.Single": oValues[k] = (float) 4.5 + i; break; } } k++; } dTbl.Rows.Add(oValues); } } } john santhosh

johnsanthosh_tr · Answer

Hi For understanding my problem, I will explain what my program does.I will give instructions, what to do , u can see that. And I will say what my requirement is ,, so that u can rectify my problem. I have a 3 textboxes in the form. Theer is a xml file with a value named "style_desc" in it.(ie, Field Names.xml in the project directory) 1st Textbox ------ give the schema file.(Input Schema.xsd from the project directory) 2nd TextBox------- give the input xml file( styleData.xml in the project directory) some about 30 values for a single field named "style_desc." 3rd TextBox-------- give ur own path to create an xml file with data's fo rthe xml schema. Then click button LOAD----- what it does is that stores the value(from the Feld Nams.xml) in an array and checks for the entered schema(ie, Input Schema.xsd) that there is ay field named "style_desc". Then if it exists in the schema then itreads the values of "style_desc" and stores into a new xml(for the third Textbox file) and the reamining fields of schema will be automatically loaded with values accodring to the datatype for about 200 values. ie, for string ---- castle hampers1, castle hampers2.... upto 200 names for float ----- 4.5, 5.5,.... upto 200 values so for the style_desc column alone(for 200 data's), first 30 values from the styleData.xml (as ther is only 30 values)and the remaining will be castle hampers31, 32.... so on. this is what I did. Now my requirement is that I have some other xml file (say billtodata.xml ) with about 30 values for a field named "billto_name".. Now I should add "billto_name" along with "style_desc" in the xml file(Field Names.xml) . Now it should be also stored in the array and check for the schema whether there is any existence of the field named "billto_name" trhen if it exists it should read the values from billtodata.xml and load it into the new xml with the values for the billto_name. so Like this I will be adding mor xml file with values for single field . So can u please finish it for me . or else give the correct idea with some coding help. I think u will be clear now .. This is very urgent need for me.Here is my coding part. please correct me to do my requrement. here is my coding part where under the load button I have this.there will some *****************. that is the place wher I will load styledata.xml. private void button2_Click(object sender, System.EventArgs e) { ArrayList FiledNames = new ArrayList(); XmlDocument xdc = new XmlDocument(); //Read the file which contain the field names xdc.Load(@"C:\CDEV	estdatagenerator\Field Names.xml"); XmlNodeList nodFields = xdc.DocumentElement.SelectNodes("//item"); for(int i=0; i<nodFields.Count;i++) FiledNames.Add(nodFields.Item(i).InnerXml); ArrayList MatchList = new ArrayList(); //Read the schema file dataSet1.ReadXmlSchema(txtSchema.Text); foreach (DataTable dTbl in dataSet1.Tables) { int i = 0; foreach (DataColumn dColmn in dTbl.Columns) { for (int y=0; y < FiledNames.Count; y++) { if(dColmn.ColumnName.ToString() == FiledNames[y].ToString()) { MatchList.Add(new FieldList(i, FiledNames[y].ToString())); break; } } i++; } } //Load the data file xdc.Load(txtData.Text);**************************** ************************ foreach (DataTable dTbl in dataSet1.Tables) { object[] oValues = new object[dTbl.Columns.Count]; String sXPath = "//" + dTbl.TableName.ToString(); XmlNodeList nodeRows = xdc.SelectNodes(sXPath); for(int i = 0; i <= 200; i++) { int k=0; foreach (DataColumn dColmn in dTbl.Columns) { bool bFound = false; foreach(FieldList FL in MatchList) { if(dColmn.ColumnName.ToString() == FL.ColDesc.ToString() && i<nodeRows.Count) { String xPath = dColmn.ColumnName.ToString(); XmlNode node; node = nodeRows.Item(i).SelectSingleNode(xPath); if(node != null) { oValues[k] = node.InnerText; bFound = true; break; } } } if(!bFound) { switch(dColmn.DataType.ToString()) { case "System.String": oValues[k] = (string) "castle Hampers" + i; break; case "System.Int32": oValues[k] = (int) 66 + i; break; case "System.DateTime": oValues[k] = new DateTime(2004,01,30).AddDays(i * 1); break; case "System.Decimal": oValues[k] = new Decimal(1900.20) + i; break; case "System.Int16": oValues[k] = (short) 3256 + i; break; case "System.Int64": oValues[k] = (long) 400 + i; break; case "System.Double": oValues[k] = (double) 8888 - i; break; case "System.Single": oValues[k] = (float) 4.5 + i; break; } } k++; } dTbl.Rows.Add(oValues); } } } -------------------------------- then I have alos added a class before doing this as follows. using System; namespace testdatagenerator { public class FieldList { public int ColIndex; public string ColDesc; public FieldList(){} public FieldList(int ClIndex, string ClDesc) { this.ColIndex = ClIndex; this.ColDesc = ClDesc; } } } ------------------------- so please help me to this. santhosh

reading two or more xml filesusing xml document

Vaikesh K P