Binding and Editing XML Data (Urgent)

[ashasivan]

Hi,

Please help me as soon as possible for the following problem. It is very very urgent.

I have an XML file as follows:

<?xml version="1.0" standalone="yes"?>
<Employee>
<em name="Asha" id="1">
<details>456</details>
<details>897</details>
</em>
<em name="Siva" id="2">
<details>890</details>
<details>234</details>
</em>
<em name="Lekshmi" id="3">
<details>3768</details>
<details>777</details>
</em>
....

....

....

</Employee>



I am unable to bind these data in GridView.

Please help me to bind and edit these XML data using GridView Control or Repeater Control.

It is very urgent.


Thanks in Advance,

Regards,

Asha Sivan

[dip_developer]

Hi,

Please help me as soon as possible for the following problem. It is very very urgent.

I have an XML file as follows:

<?xml version="1.0" standalone="yes"?>
<Employee>
<em name="Asha" id="1">
<details>456</details>
<details>897</details>
</em>
<em name="Siva" id="2">
<details>890</details>
<details>234</details>
</em>
<em name="Lekshmi" id="3">
<details>3768</details>
<details>777</details>
</em>
....

....

....

</Employee>



I am unable to bind these data in GridView.

Please help me to bind and edit these XML data using GridView Control or Repeater Control.

It is very urgent.


Thanks in Advance,

Regards,

Asha Sivan

convert your xml to a DataSet.....then bind DataSet with your DataGrid or GridView...

try this..............

 
string myXMLfile = @"C:\myXMLFileName.xml";
    DataSet ds = new DataSet();
    // Create new FileStream with which to read the schema.
    System.IO.FileStream fsReadXml = new System.IO.FileStream 
        (myXMLfile, System.IO.FileMode.Open);
    try
    {
        // Bind datagrid with dataset or gridview
 
        ds.ReadXml(fsReadXml);
        dataGrid1.DataSource = ds;
        dataGrid1.DataMember = "Cust";
    }
    catch (Exception ex)
    {
 MessageBox.Show(ex.ToString());
    }
    finally
    {
 fsReadXml.Close();
    }
 

[ashasivan]

Thanks for your reply.
Actually I want to edit the data also and it should be in ASP.NET.. not in C#

[dip_developer]

Thanks for your reply.
Actually I want to edit the data also and it should be in ASP.NET.. not in C#

Two things I have to say....
1.Firstly...you can make this datagrid editable......
look here...
http://www.megasolutions.net/kb/Edit..._DatagRid.aspx

2. secondly what do you mean by
it should be in ASP.NET.. not in C#??

do you know what you are saying actually????

ASP.net is a platform by which you can make an Application with an web user interface.......this application can be created with any language like vb/c#/j#...........I have written the code in C#.net......its my choice......you may write your code in vb.net.....but in any way the application is an ASP.net application.......

then what is the meaning of
it should be in ASP.NET.. not in C#??

[ashasivan]

I mean that I doing a web application. So the gridview control from asp.net have to use. Not for the windows application.

And also I know that GridView can be made editable. My problem is if I am having same tag then I am unable to bind it.

<?xml version="1.0" standalone="yes"?>
<Employee>
<em name="Asha" id="1">
<details>456</details>
<details>897</details>
</em>
<em name="Siva" id="2">
<details>890</details>
<details>234</details>
</em>
<em name="Lekshmi" id="3">
<details>3768</details>
<details>777</details>
</em>
....

....

....

</Employee>

here in this file there are more than 1 details tag. If it is only one is there, I am able to bind and edit data. But the problem is more than 1 tag with same name.


I think you understand my problem.

Asha Sivan