using .NET web service (Dataset) from progress OpenEdge 4GL
- by jasperdmx
I created web service in C# .net with input parameter : DataSet
in other side, i need to use this web service from progress OpenEdge 4GL 10.1 (not 10.2)
the problem is Dataset in OpenEdge cant match with DataSet in .net.
always return 0 in the result
I'm C# programmer, so dont have deep knowledge in porgress. I did research in progress forum, but not a good result.
any help ?
thanks in advance.
*codes*****
//web service : C# .net
[webmethod]
public int getResult(DataSet ds)
{
DataTable tbl = ds.Tables["datas"];
int result=0;
foreach (DataRow dr in tbl.Rows){ //only 1 record = 1 row
result = Convert.toInt32(dr["field1"]); }
return result;
}
//progress OpenEdge 10.1
--- create and fill temp-table : field1 = 30 and only 1 record
--- create dataset and bind to temp-table
--- connect to web service
--- call webmethod :
define variable result as integer no-undo.
RUN getResult IN hPortType(INPUT dataset,OUTPUT result).
message result view-as alert-box info button ok. --- RESULT ALWAYS 0
/****/
anyone know how to "bridge" dataset in progress openedge to .net dataset ?
note: this web service works well if called from .net