public void MssGetMyCustomers(out OutSystems.NssGetDatasetRL.RLCustomerRecordList ssRL) { ssRL = new RLCustomerRecordList(null); MyWs.Service ws = new MyWs.Service(); System.Data.DataSet ds = ws.GetDataSet(); foreach (System.Data.DataRow dr in ds.Tables[0].Rows) { RCCustomerRecord rec = new RCCustomerRecord(); rec.ssSTCustomer.ssCompanyName = dr[0].ToString(); rec.ssSTCustomer.ssContactName = dr[1].ToString(); ssRL.Append(rec); } // MssGetMyCustomers }
using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data; using System.Data.SqlClient; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class Service : System.Web.Services.WebService { public Service () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string HelloWorld() { return "Hello World"; } [WebMethod] public System.Data.DataSet GetDataSet() { SqlConnection cn = new SqlConnection("server=localhost;uid=sa;pwd=sa;database=northwind"); SqlCommand cmd = new SqlCommand("select CompanyName, ContactName from Customers", cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ds.DataSetName = "myDataSetName"; da.Fill(ds, "Customer"); da.Dispose(); cn.Close(); return ds; } }