Pfthb

hello every body i am new to c# and now im trying to add rows to datagridview using query and invoke but the problem is whenever i try to insert data to table in rewrites all rows so just one row that has the last verified value shown in the rows. i have tried so many thing but i dont know where the problem is. this is my code:

 XDocument xdoc = XDocument.Load("demo.xml");
 var query = from key in xdoc.Descendants("user")
 where key != null && (key.Element("clientno").Value == recieveddata)
 select new
 
 //listBox3.Items.Add(key.Element("name")+""+key.Element("lastname"));
 نام = key.Element("name").Value +" "+ key.Element("lastname").Value,
 // خانوادگی = key.Element("lastname").Value,
 ورزش = key.Element("noeozviat").Value,
 تاریخ = key.Element("date").Value,
 عضویت = key.Element("duration").Value,
 جلسات = key.Element("jalasat").Value
 ;dataGridView1.Invoke(new Action(() => dataGridView1.DataSource = query.ToList()));

please help me on this.

You are creating a new list and setting it as the data source every time. What you should be doing is creating a class for each element (at the moment you are using an anonymous type), then ADD new elements when you run the query and set this list as the new data source.

Something like this:

class Thing
 
 public string نام get;set;
 // Etc


List<Thing> items = new List<Thing>(); // <- should be a class member variable, not a local variable

XDocument xdoc = XDocument.Load("demo.xml");
var newItems = from key in xdoc.Descendants("user")
 where key != null && (key.Element("clientno").Value == recieveddata)
 select new Thing
 
 نام = key.Element("name").Value +" "+ key.Element("lastname").Value,
 ورزش = key.Element("noeozviat").Value,
 تاریخ = key.Element("date").Value,
 عضویت = key.Element("duration").Value,
 جلسات = key.Element("jalasat").Value
 ;
items.AddRange(newItems.ToList());
dataGridView1.Invoke(new Action(() => dataGridView1.DataSource = items));