Last post Jul 30, 2013 04:54 AM by smilu.net
Jul 30, 2013 04:54 AM|smilu.net|LINK
I have a webservice in which i'm returning a DataSet. The DataSet contains two DataTables Namely TotalSummary and StateSummary.
TotalSummary = It gives us a summary of the Employees in the Company. Always the fields are fixed and only one row will be fetched for this table.
StateSummary = Gives you the summary with respect to each state from which the Employee is employed to the company. Rows cannot be determined. The records are fetched in a Pivot Table manner.
State TotMale TotFemale
ABC 3 2
XYZ 1 3
When I return the dataset its giving me the XML data of the DataTables.
Here is what I get when Webservice is working.
<TotalSummary diffgr:id="TotalSummary1" msdata:rowOrder="0">
<StateSummary diffgr:id="StateSummary1" msdata:rowOrder="0">
<StateSummary diffgr:id="StateSummary2" msdata:rowOrder="1">
Now, in the second table "StateSummary" I have StateName which is unique in each row and also the no of records in this table cannot be determined as it may contain many states from which employees are working on that particular
Now my question is?