Advice on a simple application

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I am trying to build a very simple app.. two actually but they both do
the same thing to each other.

I need to Compare the data retrieved from the MyApplication to the
data retrieved from MyOtherApplication using Web Services.

I aready have the two apps built and they each will retrieve the
records from the resident DB.. but I now need to expose the data from
one application to the other application using web services.

I believe I just need to write the same code I wrote to pull from my
database but just add it to the Web service... I just don't have the
language at my finger tips

Thank you in advance
 
Thanks you Steve.. I should have been more specific.. it is the code
that I need to insert that is what is giving me difficulty:) I know it
must be easy.. but I am not a formal developer...
 
I'd suggest passing a DataSet to the web service to use for your comparison.
 
Exactly what i was thinking.. I know you must be getting to that point
of "what is up with this guy..." etc..

What i Have done is reubuilt the dataset I used to display within the
application.. now I know I should be able to reuse the original
dataset... (inheritance being the sexy thing about .net ).

But what i Have is as follows:

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Diagnostics;
using System.Web;
using System.Web.Services;

namespace IASTC_GAIHR
{
/// <summary>
/// Summary description for wsPerson.
/// </summary>

public class wsPerson : System.Web.Services.WebService
{
public wsPerson()

{
//CODEGEN: This call is required by the ASP.NET Web Services Designer
InitializeComponent();

}
[WebMethod]
public DataSet personList()
{
string commandString = "Select * from tr_prsn";
string connectionString = "provider=Microsoft.JET.OLEDB.4.0; "
+ "data source = c:\\Inetpub/wwwroot/IASTC_GAIHR/DB/StrawManDB.mdb";
OleDbDataAdapter wsDataAdapter = new
OleDbDataAdapter(commandString,connectionString);

DataSet dsWSDataSet = new DataSet();
wsDataAdapter.Fill(dsWSDataSet,"Persons");


}

Right now I am getting ablue squiggly under the personlist saying "Not
all code paths return a value:" presumably this is talking about the
fact htat i am not retuning anything to the caller of the method
(class?).. thanks again for your help
 
Back
Top