Find data in dataset and assign cell value to a variable

Question

Hi I cannot read the value from the cell. Pls help. The program should read data from an XML file(without schema) and find value from one cell. Here is my code : DataSet dsLogon = new DataSet(); dsLogon.ReadXML(Server.MapPath(XMLFile.XML); DataView dvServer = new DataView(dsLogon.Tables[Server]; dvServer.Sort = Name; dvServer.RowFilter = Name = ' + this.Server.Text + '; this.AppHost = dvServer.Table.Rows[ServerIP].ToString(); Thanks Wilson

Andrzej Wegierski · Answer

There're some Find methods: 1. On Rows collection: Find( ) where arg is an object - when primary key is on one field or object array - when primary key is on many fields. You can use strings etc. instead of objects. If there's no key in collection - result is null. Using: DataRow xRow=myTable.Rows.Find(searched-key-value); DataRow xRow=myTable.Rows.Find(new object[]{ searched-key-value1 .... }); 2. On DataView - on fields used to sort DatView. Return value is row number -1 when not found. Using: int xRow=myTable.DefaultView.Find(searched-key-value); int xRow=myTable.DefaultView.Find(new object[]{ searched-key-value1 .... }); See Select() datatable method and FindRows() dataview methods in help as well.

wilsonwu · Answer

Thanks. I can get the value now. But how to user Find() ? Thanks again Wilson

Andrzej Wegierski · Answer

1. There's no need to create DataView. DataTable has own DefaultView 2. dvServer.Table.Rows has a numeric indexer [rownumber] to get the row and next You can get column (property) value [ServerIP] 3. To find values from dataview use Find(new object[]{ ... }) method returning row number etc. or filtering (next use row 0 if exists) 4. To assign a value use dvServer[rownumber][fieldname]=something instead of using Table.Rows. Row number in datatable is not equal to row number in dataview - because of sorting or filtering.

Andrzej Wegierski · Answer

Sorry.Doubled