bind xml to gridview

Posted by Saratvaddilli under C# on 3/25/2013 | Points: 10 | Views : 2122 | Status : [Member] [MVP] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi all ,
i had an xml , i want to bind name to grid-view header and values under the name


 <row>
    <var name="&quot;ConcessionaryName&quot;" value="&quot;L&amp;T&quot;" />
    <var name="&quot;CountOfRecords&quot;" value="1" />
    <var name="&quot;Amount&quot;" value="&quot;Rs.25.00&quot;" />
    <var name="&quot;FileName&quot;" value="&quot;ConcessionaireSettlement_24012013&quot;" />
    <var name="&quot;Status&quot;" value="&quot;Generated&quot;" />
    <var name="&quot;Date&quot;" value="12/12/12" />
  </row>

i want to bind name to gridview header and value to gridview items

Please see the attached image for required output

Attachment

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 3/25/2013 [Member] [MVP] Bronze | Points: 25

0	try his code DataTable dt = new DataTable(); dt.ReadXml(Server.MapPath("Test.xml")); Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Saratvaddilli, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Saratvaddilli on: 3/25/2013 [Member] [MVP] Bronze | Points: 25

0	it will not fulfill my requirement , just binding is not enough it should bind name to header and values as items in the gridview Thanks and Regards V.SaratChand Show difficulties that how difficult you are Saratvaddilli, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 3/25/2013 [Member] [MVP] Bronze | Points: 25

0	hi post your xml file. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Saratvaddilli, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Saratvaddilli on: 3/25/2013 [Member] [MVP] Bronze | Points: 25

0	<?xml version="1.0" encoding="utf-8" standalone="yes"?> <root> <row> <var name=""ConcessionaryName"" value=""L&T"" /> <var name=""CountOfRecords"" value="1" /> <var name=""Amount"" value=""Rs.25.00"" /> <var name=""FileName"" value=""ConcessionaireSettlement_24012013"" /> <var name=""Status"" value=""Generated"" /> <var name=""Date"" value="12/12/12" /> </row> <row> <var name=""ConcessionaryName"" value=""Soma"" /> <var name=""CountOfRecords"" value="2" /> <var name=""Amount"" value=""Rs.3176.00"" /> <var name=""FileName"" value=""ConcessionaireSettlement_24012013"" /> <var name=""Status"" value=""Generated"" /> <var name=""Date"" value="13/12/12" /> </row> <row> <var name=""ConcessionaryName"" value=""GMR"" /> <var name=""CountOfRecords"" value="3" /> <var name=""Amount"" value=""Rs.4171.00"" /> <var name=""FileName"" value=""ConcessionaireSettlement_24012013"" /> <var name=""Status"" value=""Generated"" /> <var name=""Date"" value="14/12/12" /> </row> <row> <var name=""ConcessionaryName"" value=""Jaypee"" /> <var name=""CountOfRecords"" value="22" /> <var name=""Amount"" value=""Rs.8575.00"" /> <var name=""FileName"" value=""ConcessionaireSettlement_24012013"" /> <var name=""Status"" value=""Generated"" /> <var name=""Date"" value="15/12/12" /> </row> <row> <var name=""ConcessionaryName"" value=""sarat"" /> <var name=""CountOfRecords"" value="22" /> <var name=""Amount"" value=""Rs.8575.00"" /> <var name=""FileName"" value=""ConcessionaireSettlement_24012013"" /> <var name=""Status"" value=""Generated"" /> <var name=""Date"" value="15/12/12" /> </row> </root> Thanks and Regards V.SaratChand Show difficulties that how difficult you are Saratvaddilli, if this helps please login to Mark As Answer. \| Alert Moderator

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<root>
<row>
<var name=""ConcessionaryName"" value=""L&T"" />
<var name=""CountOfRecords"" value="1" />
<var name=""Amount"" value=""Rs.25.00"" />
<var name=""FileName"" value=""ConcessionaireSettlement_24012013"" />
<var name=""Status"" value=""Generated"" />
<var name=""Date"" value="12/12/12" />
</row>
<row>
<var name=""ConcessionaryName"" value=""Soma"" />
<var name=""CountOfRecords"" value="2" />
<var name=""Amount"" value=""Rs.3176.00"" />
<var name=""FileName"" value=""ConcessionaireSettlement_24012013"" />
<var name=""Status"" value=""Generated"" />
<var name=""Date"" value="13/12/12" />
</row>
<row>
<var name=""ConcessionaryName"" value=""GMR"" />
<var name=""CountOfRecords"" value="3" />
<var name=""Amount"" value=""Rs.4171.00"" />
<var name=""FileName"" value=""ConcessionaireSettlement_24012013"" />
<var name=""Status"" value=""Generated"" />
<var name=""Date"" value="14/12/12" />
</row>
<row>
<var name=""ConcessionaryName"" value=""Jaypee"" />
<var name=""CountOfRecords"" value="22" />
<var name=""Amount"" value=""Rs.8575.00"" />
<var name=""FileName"" value=""ConcessionaireSettlement_24012013"" />
<var name=""Status"" value=""Generated"" />
<var name=""Date"" value="15/12/12" />
</row>
<row>
<var name=""ConcessionaryName"" value=""sarat"" />
<var name=""CountOfRecords"" value="22" />
<var name=""Amount"" value=""Rs.8575.00"" />
<var name=""FileName"" value=""ConcessionaireSettlement_24012013"" />
<var name=""Status"" value=""Generated"" />
<var name=""Date"" value="15/12/12" />
</row>
</root>

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Saratvaddilli, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: aswinialuri-19361 on: 3/25/2013 [Member] Starter | Points: 25

0	hi Try this ithink it is useful to you In XMl file <?xml version="1.0" encoding="utf-8" ?> <Employee> <Emp> <Empid>1</Empid> <EmpName>aswini</EmpName> </Emp> <Emp> <Empid>2</Empid> <EmpName>aluri</EmpName> </Emp> </Employee> and in .aspx.cs page protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { getdata(); } } public void getdata() { XmlTextReader xtr = new XmlTextReader(Server.MapPath("XMLFile1.xml")); DataSet dt = new DataSet(); dt.ReadXml(xtr); xtr.Close(); if (dt.Tables.Count != 0) { GridView1.DataSource = dt; GridView1.DataBind(); } } Thanks & Regards Aswini Aluri Mark as Answer if it helps you Thanks&Regards Aswini Aluri Saratvaddilli, if this helps please login to Mark As Answer. \| Alert Moderator

hi
Try this ithink it is useful to you
In XMl file
<?xml version="1.0" encoding="utf-8" ?>
<Employee>
<Emp>
<Empid>1</Empid>
<EmpName>aswini</EmpName>
</Emp>
<Emp>
<Empid>2</Empid>
<EmpName>aluri</EmpName>
</Emp>
</Employee>

and in .aspx.cs page

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
getdata();
}

}
public void getdata()
{
XmlTextReader xtr = new XmlTextReader(Server.MapPath("XMLFile1.xml"));
DataSet dt = new DataSet();
dt.ReadXml(xtr);
xtr.Close();
if (dt.Tables.Count != 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
}

Thanks & Regards
Aswini Aluri

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

Saratvaddilli, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts