Find data in dataset and assign cell value to a variable

wilsonwu

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski22y ago
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.
+1
wilsonwu22y ago
Thanks. I can get the value now. But how to user Find() ? Thanks again Wilson
+1
Andrzej Wegierski22y ago
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.
+1
Andrzej Wegierski22y ago
Sorry.Doubled
+1