Hi guys i need your help, i am trying to read an xmlfile which is on the listbox, after reading it i want to bind the data to GridView, i can read directly from the location where i have saved the XMLfiles but now i want to select it from the listBox and display to GridView. The folowing is the code that i did to put the xmlFile to the ListBox.

    for (int ix = 0; ix < ListBox1.Items.Count; ix++)
                    {
                        lblMessage.Text = "Processing file: " + ix + 1;
                        string xmlfile = ListBox1.Items[ix].Text;
                        try
                        {
                            DataSet ds = new DataSet();
                            ds.ReadXml(xmlfile, XmlReadMode.InferSchema);
                            GridView1.DataSource = ds;
                            GridView1.DataMember = ds.Tables[ix].TableName;
                            GridView1.DataBind();
                            Set2 = new DataSet();
                            Set2.ReadXml(xmlfile, XmlReadMode.InferSchema);
                            Tab2 = new DataTable();
                            Tab2 = Set2.Tables[0];
                            {

                                j++;

                                for (int i = 0; i < Tab2.Columns.Count; i++)
                                {
                                    string xx = Tab2.Columns[i].ToString();
                                    string yy = Tab2.Rows[0][xx].ToString();
                                }
                            }
                        }
                        catch (Exception exp2)
                        {
                            j++;
                            Debug.Print("Error in " + xmlfile + "\n\n" + exp2.Message);
                        }

                    }
                    lblMessage.Text = "Done!";
                }
                else
                {
                    lblMessage.Text = "List is empty!";
                }
            }
            catch (Exception e)
            {
                lblMessage.Text += "Exception: " + e.ToString();
            }

        }

        protected void btnRead_Click1(object sender, EventArgs e)
        {
            readXMLFiles();
        }

        protected void btnExract_Click(object sender, EventArgs e)
        {
            //DataSet dataSet = new DataSet();
            //dataSet.ReadXml("C:\\Users\\PraiseM\\Desktop\\Read\\Test.xml");
            //ListBox1.DataSource = dataSet.Tables[0];
            //GridView1.DataBind();
        }
    }
}

Recommended Answers

If I understand you correctly, you want to select the xml file path from the listbox. The .SelectedItem.ToString() property should be able to give you the selected file path, instead of looping through all the listbox items.

Jump to Post

All 3 Replies

If I understand you correctly, you want to select the xml file path from the listbox. The .SelectedItem.ToString() property should be able to give you the selected file path, instead of looping through all the listbox items.

tinstaafl

Thanks it works after i used .SelectedItem.ToString() property.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.