Update to XML using DataGridView (LINQ)

@Mamta, Suthish
Thanks. I will try to implement into my code.  Shall post back results. Hope it works.

Ok..

Yes Mamta is right. Or you need to generate dynamic datatable at runtime.

refer example
 

Leone,
I did quite some research and this is what I found:
You will need to create a class represnting your XML entity (eg: dept or employees, whatever)
Use a BindingList. The BindingList acts similar to List and can be used as a datasource for your DGV, the advantage of BindingList is that it supports two way data binding so that any changes in your UI will reflect in the XML file.
http://msdn.microsoft.com/en-us/library/ms132679%28VS.80%29.aspx#Y509
BindingList bl =  new BindingList(query.ToList());
Then do this:
dataGridView1.DataSource  = bl;
After this, two way data binding will work perfectly.
Hope this helps.
-Mamta

@Sam Hobbs
Are you suggesting to add the query.ToList() to a DataTable, and then use the DataTable as DataSource? That would be great. Then, I think i might be able to recover the DataSource into an DataTable object.
You have any idea how to save the output of LINQ[XML] query variable into DataTable?
PS: Have added elaboration from my 3rd post to the first one to make it more readable

I might not understand the problem either, but I think you are doing it backwards. First understand that XML lacks many of the conveniences that database tables have. What you need to do is to design your applicaiton to use a DataTable as the primary container of data and the DataGridView as the UI insterad of using the DataGridView as the primary container of data and a DataTable as a way to serialize the data out. Then you can bind the DataGridView to the DataTable and I think the DataTable or DataSet class has methods for serializing XML in and out, but I am not sure of the details.
 
Is that going in the direction you want to go?

@Suthish Nair
Please go through the previous posts again. You are not able to understand the problem. Problem is not with the part of the code that you are mentioning. Appreciate that you are trying to help.

your code must work..

or trylike this... am assuming empxmldoc as XDocument object

var query = from e in empxmldoc.Descendants("emp")
                 where e.Attribute("dept").Value == "dept01"
                 select new { Name = e.Element("name").Value, Dept=e.Element("dept").Value, Salary=e.Element("sal").Value};
           
DataGridView1.DataSource = query.ToList();

Or upload the xml file.

@Mamta
Glad you got the issue.

Can anyone suggest any way?

Do i have to use XMLserialization concept here?

Let me elaborate the situation,

var query = from e in empxmldoc.Descendants("emp")
                   where (string)e.Attribute("dept") == "dept01";
                   select new { Name = e.Value,    Dept=e.Attribute("dept").Value, Salary=e.Attribute("sal").Value};
           
DataGridView1.DataSource = query.ToList();


Above illustrates how i am loading my xml data into DataGridView.

But, on cell value changed, row added events, I tried

1. DataTable dt = DataGridView1.DataSource;
2. DataSet ds = DataGridView1.DataSource;
3. DataTable dt = (DataTable)DataGridView1.DataSource;
4. DataSet ds = (DataSet)DataGridView1.DataSource;

But, cannot get the data into any of them.

Leone,
Sorry I missed out that part. Perhaps this link may be more useful, you can serialize your List to Xml as shown in this link.
http://www.switchonthecode.com/tutorials/csharp-tutorial-xml-serialization

You can use the DataSet.WriteXml() method.

http://msdn.microsoft.com/en-us/library/system.data.dataset.writexml(v=VS.90).aspx