How to bind xml to datagrid

Question

hi i have a string from xml below like : string str= @ xmlns:xsd=http://www.w3.org/2001/XMLSchema> divid1 divid2 ; i want bind it to datagrid please help me how to it do ? thanks

Jignesh Trivedi · Answer

Hi Try following code string str = @ http://www.w3.org/2001/XMLSchema-instance  xmlns:xsd= http://www.w3.org/2001/XMLSchema > divid1 divid2 ; StringReader theReader = new StringReader(str); DataSet theDataSet = new DataSet(); theDataSet.ReadXml(theReader); Gridview1.DataSource = theDataSet; Hope this help.

Jignesh Trivedi · Answer

Hi Try following code string str = @ http://www.w3.org/2001/XMLSchema-instance  xmlns:xsd= http://www.w3.org/2001/XMLSchema > divid1 divid2 ; StringReader theReader = new StringReader(str); DataSet theDataSet = new DataSet(); theDataSet.ReadXml(theReader); Gridview1.DataSource = theDataSet; Hope this help.

James Tomar · Answer

Hi Try this Article Link: http://www.extremeexperts.com/Net/Articles/BindingXMLtoDataGrid.aspx Thanks

Gohil Jayendrasinh · Answer

i think this link is useful for you . http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource.aspx

Vahid Bakhtiary · Answer

thanks for your answer i try it and the code was right but in my project i can't use of DataSet now i how to it do please help me thanks

Satyapriya Nayak · Answer

Hi Vahid Try this... Untitled Page using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { // string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; protected void Page_Load(object sender EventArgs e) { //SqlConnection con = new SqlConnection(connStr); //con.Open(); DataSet reportData = new DataSet(); reportData.ReadXml(Server.MapPath(test.xml)); GridView1.DataSource = reportData; GridView1.DataBind(); //con.Close(); } } test.xml I1 20 I2 25 I3 30 Thanks

Vahid Bakhtiary · Answer

thanks for your answer i try it and your code is right but in datagrid display below like : item divid1 divid2 but i want display name every columns be name my node for example below like: ID divid1 divid2 or if i have a xml below like : divid1 divid2 in datagrid dispaly below like: ID Age divid1 20 please help me how to define columns with name every node thanks

Dharmesh sharma · Answer

Hello see this code .... void Country() { List _obj_country = new List (); XmlDocument doc = new XmlDocument(); String value = ; doc.Load(http://where.yahooapis.com/v1/countries?appid=[your yahoo API]); XmlNodeList NewsList = doc.GetElementsByTagName(places); foreach (XmlNode node in NewsList) { foreach (XmlNode sub_node in node) { XmlElement ConnectionElement = (XmlElement)sub_node; value = ConnectionElement.GetElementsByTagName(name)[0].InnerText; _obj_country.Add(value); } } datagrid.DataSource = _obj_country; datagrid.DataBind(); } This is yahoo api use code in this code get xml from yahoo and you can bind into grid and dropdown thanks