How to fire query on dataset?

[Sachin Gedam]

Hello Friends, I am facing on problem regarding XML and slow performance. Actually I am reading data from XML node by node. Now what i am thinking that, we can convert XML file to dataset and we can access data from dataset. But I am not able to get a way to access data from dataset. Can you please tell me how to fire query on dataset? Like if I collect all data from XML to dataset now want to get all employee having sal>=5000 How to fire this query on dataset? And resultant should be bindable to grid. Sachin Gedam (Software Engg.) Pune India

[Irshad Ahmad Sulaimani]

Dear Sachin:) You can do this simply by using Data table's select m,ethod. By specifying the condition u'll be returned with the required rows. for example: DataSet ds ; ------// Get the dataset from XML File or from From Database as needed ------ ----- ds.Tables[0].TableName = "Table1"; // It will return all rows in which value in the salary column >=5000 DataRow[] dr=ds.Tables[0].Select("Salary >=5000 "); Hope it works.:rose: Bye, Irshad Ahmad Irshad A Sulaimani

[anj1983]

Could you tell me where i could find articles regarding the use of dataset that could help me understand clearly and indepth the use of dataset. leo

[Irshad Ahmad Sulaimani]

Dear Mate:) Msdn is the good place to learn about dataset. U can also search dot net sites under ADO.NET section to read articles about dataset. Regards:-O, Irshad Ahmad Irshad A Sulaimani