Xml binding to gridview

Question

I serialized the dataset to xml file in BLL i.e Middle tierI have this xml file.Now i want to attach this xml file to gridview without using dataset.HOW? xml file content: 10 Orgnz Organization 200002 12 Bnk Bank 100000

mohd sajid · Answer

Thanks for Answering. But i want to know is there any way to bind xml elements to gridview through iteratingwithout use of dataset or datatable.

Satyapriya Nayak · Answer

Data1.xml file 10 Orgnz Organization 200002 12 Bnk Bank 100000 protected void btn_showdata_Click(object sender EventArgs e) { string filePath = Server.MapPath(Data1.xml); //Table Must match with the element name in your file DataTable dt = new DataTable(Table); //Add Columns in datatable //Column names must match XML File nodes dt.Columns.Add(CustomerTypeID typeof(System.String)); dt.Columns.Add(CustomerTypeCode typeof(System.String)); dt.Columns.Add(CustomerType typeof(System.String)); dt.Columns.Add(TransactionLimit typeof(System.String)); //Read XML File And Display Data in GridView dt.ReadXml(filePath); GridView1.DataSource = dt; GridView1.DataBind(); }