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();
}
}
}