.net DataSet and web services, .net DataSet and web services

[Elango]

Hi,
I have written a function in my webservices to return a dataset. When i port  the returned webservices dataset to the DataGrid's dataProvider, it's not  porting to it. If I check with the for in loop i see all the datas and it's not  displaying in flash components. Please anyone help on this ASAP.

[WebMethod]
public DataSet Alerter()
{
SqlConnection myConnection;
SqlCommand myCommand;
SqlDataAdapter myDataAdapter;
DataSet myDataSet;
String sql = "SELECT ProductName,UnitPrice,QuantityPerUnit FROM Products";
String conn = "Server=localhost;uid=sa;pwd=supportmm;database=Northwind";
myConnection = new SqlConnection(conn);
myConnection.Open();
myCommand= new SqlCommand(sql, myConnection);
myDataAdapter = new SqlDataAdapter(myCommand);
myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet,"Products");
return myDataSet;

[Jorge Solis]

Hi Elango, welcome to the Boards!

If you're using the Webservices Connector, you should pass an xml document, not a recordset. To pass a recordset, you need to use Remoting.

Jorge

[Elango]

Hi,
  I got the result in my flash app, but can't able to handle those values. I just need some help for that. How to handle the .net dataset values inside flash. If i specify the return value to a datagrid's dataProvider too it doesn't support. Is there any other way to handle. Please help on this  

Thanks

[Jorge Solis]

Flash can't understand .Net recordsets (nor Java or PHP ones) All those languages should use Flash Remoting to pass directly recordsets to Flash. If you don't have Remoting support in your server, name/value pairs or XML are options. Check http://www.flash-db.com/Tutorials/loading/

Jorge

[hugobossv8]

I'm trying to do the same thing now with the WebServiceConnector.  I've done it with remoting already, but I want to figure out how to do it with WebServices.  Do I need to bind the WebServiceConnector to the XMLConnector? Or do I need to set data returned from the WebServiceConnector equal to XML object and then loop through the XML object to add the .NET dataset to DataGrid?

Thanks.

[Jorge Solis]

Use the Webservice Connector and bind to some data component, check the example in the data tutorials from http://www.macromedia.com/support/documentation/en/flash/index.html

Jorge

[hugobossv8]

Thanks Jorge,

This is what I tried doing at first, but the .NET dataset is not natively understood by Flash when it's loaded from a Web Service (like it is with remoting).  So when I tried to bind results to the dataprovider, it doesn't work.  What I want to know is should I try to bind the results to an XML connector, or do I need to loop through the recordset some how in actionscript?

Thanks.

[Jorge Solis]

As exposed in the posted tutorial, you need to import the schema from your WSDL to Flash trough the Webservice Connector and then bind trough your data components. If your service outputs an XML document, then XMLConnector is a choice.

Jorge

[hugobossv8]

Thanks for the quick answer Jorge (and your patience), I will go through the tutorial so I can have a better understanding of this before I open my mouth again with questions

[linxian]

I don't know and give a example for me. Thank you.
————————————————————————————
linxian163@163.com

[Jorge Solis]

Hi Linxian, welcome to the Boards !

Read posted tutorials, as hugobossv8 did, then return with your questions.

Jorge

[linxian]

XmlConnector
Webserviceconnector

Don't Work。