HELP: must implement the Add(System.Data .DataRowView) Method?

[Grigs]

I have a C# Web Service that some of the methods (ones that return integers)
work and some do not (the ones that return a DataView.

Here is some code in the WebService that is giving me the problem. The
oAllData function gets run on the initialization of the class.
DataSet oAllData = new DataSet();
[WebMethod(Descr iption="Return a DataView of the Active Notifications")]
public object GetActiveNotifi cations() {
DataView oNeededData = new DataView(oAllDa ta.Tables["Notificati on"]);
oNeededData.Row Filter = "Status = 'Active'";

return oNeededData;
}
private DataSet ConnectToDataSt ore() {
DataSet oDS = new DataSet();
oDS.ReadXml(Ser ver.MapPath("NA AData.xml"));
return oDS;
}
Here is the code that runs when I click a button. It is supposed to pass
back a DataView and then I would bind that to a DataGrid.

private void cmndGetNotifica tions_Click(obj ect sender, System.EventArg s
e) {
TestNANAA.NAWS. NANAA oWS = new TestNANAA.NAWS. NANAA();
DataView oDV = new DataView();
oDV = (DataView)oWS.G etActiveNotific ations();
dgrdData.DataSo urce = oDV ;
dgrdData.DataBi nd();
}
However, when I click the button to do it I get the following error:
Server was unable to process request. --> There was an error generating the
XML document. --> You must implement the Add(System.Data .DataRowView) method
on System.Data.Dat aView because it inherits from ICollection

Line 92:
RequestNamespac e="http://www.NAMfg.com/NAMfgWebService s/NotificationsAn dAlerts/",
ResponseNamespa ce="http://www.NAMfg.com/NAMfgWebService s/NotificationsAn dAlerts/",
Use=System.Web. Services.Descri ption.SoapBindi ngUse.Literal,
ParameterStyle= System.Web.Serv ices.Protocols. SoapParameterSt yle.Wrapped)]
Line 93: public object GetActiveNotifi cations() {
Line 94: object[] results =
this.Invoke("Ge tActiveNotifica tions", new object[0]);
Line 95: return ((object)(resul ts[0]));
Line 96: }
I need some help here. Pulling my hair out trying to figure out what to do.

TIA,
Kevin
--
Thanx,
Grigs

[Sami Vaaraniemi]

"Grigs" <Gr***@discussi ons.microsoft.c om> wrote in message
news:1E******** *************** ***********@mic rosoft.com...

I have a C# Web Service that some of the methods (ones that return integers) work and some do not (the ones that return a DataView.

Here is some code in the WebService that is giving me the problem. The
oAllData function gets run on the initialization of the class.
DataSet oAllData = new DataSet();
[WebMethod(Descr iption="Return a DataView of the Active Notifications")] public object GetActiveNotifi cations() {
DataView oNeededData = new DataView(oAllDa ta.Tables["Notificati on"]); oNeededData.Row Filter = "Status = 'Active'";

return oNeededData;
}
private DataSet ConnectToDataSt ore() {
DataSet oDS = new DataSet();
oDS.ReadXml(Ser ver.MapPath("NA AData.xml"));
return oDS;
}
Here is the code that runs when I click a button. It is supposed to pass
back a DataView and then I would bind that to a DataGrid.

private void cmndGetNotifica tions_Click(obj ect sender, System.EventArg s e) {
TestNANAA.NAWS. NANAA oWS = new TestNANAA.NAWS. NANAA();
DataView oDV = new DataView();
oDV = (DataView)oWS.G etActiveNotific ations();
dgrdData.DataSo urce = oDV ;
dgrdData.DataBi nd();
}
However, when I click the button to do it I get the following error:
Server was unable to process request. --> There was an error generating the XML document. --> You must implement the Add(System.Data .DataRowView) method on System.Data.Dat aView because it inherits from ICollection

Line 92:
RequestNamespac e="http://www.NAMfg.com/NAMfgWebService s/NotificationsAn dAler
ts/", ResponseNamespa ce="http://www.NAMfg.com/NAMfgWebService s/NotificationsAn dAle
rts/", Use=System.Web. Services.Descri ption.SoapBindi ngUse.Literal,
ParameterStyle= System.Web.Serv ices.Protocols. SoapParameterSt yle.Wrapped)]
Line 93: public object GetActiveNotifi cations() {
Line 94: object[] results =
this.Invoke("Ge tActiveNotifica tions", new object[0]);
Line 95: return ((object)(resul ts[0]));
Line 96: }
I need some help here. Pulling my hair out trying to figure out what to do.

Hi Kevin,

The short story is that you cannot return a DataView from a WebMethod
because a DataView is not XML serializable (for more information, read
http://support.microsoft.com/default...b;en-us;306134 and
http://msdn.microsoft.com/library/de...bservices.asp).

Instead of a DataView, you will need to return something that can be
serialized to XML, e.g., a DataSet or an array of custom objects.

Regards,
Sami

[Grigs]

Understood. Well, I am dealing with it at least.
Thank you, what I have done to get around the issue was when I returned a
DataSet that always worked. However, my initial DataSet has 5 tables in it.
I have adjusted the WS to now create an empty DataSet and add new DataTable
and I fill in the values and return that.

Works like a champ, thanks again,
Kevin