Can you please share an example for the same thing which has been properly explained with code. I tried to google a lot but couldnot find anything which is resolving my purpose
[Serializable]
public class FlexiVouchersList
{
public Operators Operators;
}
[Serializable]
public class Operators
{
public Reliance Reliance;
}
[Serializable]
public class Reliance
{
public string OperatorId { get; set; }
[XmlElement]
public Circles[] Circles { get; set; }
}
Its creating the objects but now in circles I want to get the Data of AllCircels and circleid =0
and Punjab=1 and so on.
But for this do i have to create every class for each node.. Means seprate class for reliance , Idea and so on....
And also will i have to declare every class or method to get circle id for Punjab,WestBengal and so on. Please help....
The problem is that if i do then the work would be equal to manual copy and paste of data directly into database becuase circles would be different for every didfferent operator....
vermaanubhav...
Member
3 Points
39 Posts
XML reading /parsing help required
Jan 29, 2013 01:04 AM|LINK
Hi I am new to asp.net I am trying to read an xml and parse it according to myneed. I have to bind it to dataset.
My XML is in such a way
<FlexiVouchersList>
<Operators>
<Reliance>
<OperatorId>1</OperatorId>
<Circles>
<All_Circles>...</All_Circles>
<PUNJAB>
<CircleId>1</CircleId>
<Vouchers>...</Vouchers>
</PUNJAB>
<WEST_BENGAL>...</WEST_BENGAL>
<MUMBAI>...</MUMBAI>
<MAHARASHTRA>...</MAHARASHTRA>
<DELHI>...</DELHI>
<TAMILNADU>...</TAMILNADU>
<KARNATAKA>...</KARNATAKA>
<UTTAR_PRADESH_EAST>...</UTTAR_PRADESH_EAST>
<UTTAR_PRADESH_WEST>...</UTTAR_PRADESH_WEST>
<GUJARAT>...</GUJARAT>
<ANDHRA_PRADESH>...</ANDHRA_PRADESH>
<KERALA>...</KERALA>
<MADHYA_PRADESH>...</MADHYA_PRADESH>
<RAJASTHAN>...</RAJASTHAN>
<HARYANA>...</HARYANA>
<JAMMU_AND_KASHMIR>...</JAMMU_AND_KASHMIR>
</Circles>
</Reliance>
<Idea>...</Idea>
foreach (XmlNode xnode in xdoc.SelectNodes("List/Items/Table/TableId"))
{
string tableId= xnode.InnerText;
}
I am gettting stuck as I want to store Reliance then its operatorid as 1 then ssecondly in another table
Circle then circle id for all the operators....
Its a very complex xml. Please help me with this.. as i have to get in 1 node read it skip some nodes and take only desired nodes..
Thanks
abamboria
Member
149 Points
90 Posts
Re: XML reading /parsing help required
Jan 29, 2013 12:50 PM|LINK
Here you need to learn xml Serialization & Deserialization.
Mark as Answer:- if the post helped you...
vermaanubhav...
Member
3 Points
39 Posts
Re: XML reading /parsing help required
Jan 29, 2013 04:42 PM|LINK
Can you please share an example for the same thing which has been properly explained with code. I tried to google a lot but couldnot find anything which is resolving my purpose
vermaanubhav...
Member
3 Points
39 Posts
Re: XML reading /parsing help required
Jan 29, 2013 07:14 PM|LINK
I proceeded further for the xmlserialisation but i m getting stuck here
protected void Page_Load(object sender, EventArgs e)
{
string xml = GetCircles();
XmlSerializer xs = new XmlSerializer(typeof(FlexiVouchersList));
FlexiVouchersList ds = (FlexiVouchersList)xs.Deserialize(new StringReader(xml));
}
[Serializable]
public class FlexiVouchersList
{
public Operators Operators;
}
[Serializable]
public class Operators
{
public Reliance Reliance;
}
[Serializable]
public class Reliance
{
public string OperatorId { get; set; }
[XmlElement]
public Circles[] Circles { get; set; }
}
Its creating the objects but now in circles I want to get the Data of AllCircels and circleid =0
and Punjab=1 and so on.
But for this do i have to create every class for each node.. Means seprate class for reliance , Idea and so on....
And also will i have to declare every class or method to get circle id for Punjab,WestBengal and so on. Please help....
The problem is that if i do then the work would be equal to manual copy and paste of data directly into database becuase circles would be different for every didfferent operator....
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: XML reading /parsing help required
Jan 30, 2013 11:47 PM|LINK
Hi,
I cannot see your "List" node, so please show it out and I'll do a sample for you.
And what's more, please elebrate more about what you want.
Reguards!
vermaanubhav...
Member
3 Points
39 Posts
Re: XML reading /parsing help required
Jan 31, 2013 01:32 AM|LINK
Thanks Decker for replying find the xml code.
<FlexiVouchersList>
<Operators>
<Reliance>
<OperatorId>1</OperatorId>
<Circles>
<All_Circles>
<CircleId>0</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</All_Circles>
<PUNJAB>
<CircleId>1</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</PUNJAB>
<WEST_BENGAL>
<CircleId>2</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</WEST_BENGAL>
<MUMBAI>
<CircleId>3</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</MUMBAI>
<MAHARASHTRA>
<CircleId>4</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</MAHARASHTRA>
<DELHI>
<CircleId>5</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</DELHI>
<TAMILNADU>
<CircleId>8</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</TAMILNADU>
<KARNATAKA>
<CircleId>9</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</KARNATAKA>
<UTTAR_PRADESH_EAST>
<CircleId>10</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</UTTAR_PRADESH_EAST>
<UTTAR_PRADESH_WEST>
<CircleId>11</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</UTTAR_PRADESH_WEST>
<GUJARAT>
<CircleId>12</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</GUJARAT>
<ANDHRA_PRADESH>
<CircleId>13</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</ANDHRA_PRADESH>
<KERALA>
<CircleId>14</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</KERALA>
<MADHYA_PRADESH>
<CircleId>16</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</MADHYA_PRADESH>
<RAJASTHAN>
<CircleId>18</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</RAJASTHAN>
<HARYANA>
<CircleId>20</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</HARYANA>
<JAMMU_AND_KASHMIR>
<CircleId>25</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</JAMMU_AND_KASHMIR>
</Circles>
</Reliance>
<Idea>
<OperatorId>2</OperatorId>
<Circles>
<All_Circles>
<CircleId>0</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</All_Circles>
<PUNJAB>
<CircleId>1</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</PUNJAB>
<WEST_BENGAL>
<CircleId>2</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</WEST_BENGAL>
<MUMBAI>
<CircleId>3</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</MUMBAI>
<MAHARASHTRA>
<CircleId>4</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</MAHARASHTRA>
<DELHI>
<CircleId>5</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</DELHI>
<Kolkata>
<CircleId>6</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</Kolkata>
<CHENNAI>
<CircleId>7</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</CHENNAI>
<TAMILNADU>
<CircleId>8</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</TAMILNADU>
<KARNATAKA>
<CircleId>9</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</KARNATAKA>
<UTTAR_PRADESH_EAST>
<CircleId>10</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</UTTAR_PRADESH_EAST>
<UTTAR_PRADESH_WEST>
<CircleId>11</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</UTTAR_PRADESH_WEST>
<GUJARAT>
<CircleId>12</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</GUJARAT>
<ANDHRA_PRADESH>
<CircleId>13</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</ANDHRA_PRADESH>
<KERALA>
<CircleId>14</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</KERALA>
<MADHYA_PRADESH>
<CircleId>16</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</MADHYA_PRADESH>
<BIHAR>
<CircleId>17</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</BIHAR>
<RAJASTHAN>
<CircleId>18</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</RAJASTHAN>
<HARYANA>
<CircleId>20</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</HARYANA>
<HIMACHAL_PRADESH>
<CircleId>21</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</HIMACHAL_PRADESH>
<JHARKHAND>
<CircleId>22</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</JHARKHAND>
<ORRISA>
<CircleId>23</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</ORRISA>
<ASSAM>
<CircleId>24</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</ASSAM>
<JAMMU_AND_KASHMIR>
<CircleId>25</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</JAMMU_AND_KASHMIR>
<NORTH_EAST>
<CircleId>26</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</NORTH_EAST>
<CHATTISGARH>
<CircleId>27</CircleId>
<Vouchers>
<Blank>
<description>Blank</description>
<denominations>0</denominations>
<Deno_0>
<Talktime>0</Talktime>
<Adminfee>0</Adminfee>
<Servicetax>0</Servicetax>
<Validity>0</Validity>
</Deno_0>
</Blank>
</Vouchers>
</CHATTISGARH>
</Circles>
</Idea>
<Operators>
<FlexiVouchersList>
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: XML reading /parsing help required
Jan 31, 2013 01:37 AM|LINK
First, there's something wrong with your xml codes because the two end tags aren't closed, change to this:
Then where's "List" node? I cannot find anywhere in your given xml content……？
vermaanubhav...
Member
3 Points
39 Posts
Re: XML reading /parsing help required
Jan 31, 2013 01:44 AM|LINK
View this link from here the xml is being genreated.....
And I want to get information like
Operator ie Reliance IDea,Vodafone etc
Its operator ID =1 2,3 whatever it is
Then All circles realted to reliance IDea and vodafone.
Circles are nodes like Punjab,Jammu Kashmir etc. and there circle ids like 1,2 etc.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: XML reading /parsing help required
Jan 31, 2013 01:59 AM|LINK
Can you shorten your xml contents and give us an example to tell us what you really want?
vermaanubhav...
Member
3 Points
39 Posts
Re: XML reading /parsing help required
Jan 31, 2013 02:05 AM|LINK
Here I want to get the value of Reliance with its operator ID ie 1