Re: .NET/ODBC queries Via the Internet

Tech-Archive recommends: Speed Up your PC by fixing your registry

Samuel wrote:
I have the data layer

I think that I can create an object that has the follwoing members

Datatable
Inetegr to store the error number so i can check the status
String for any error message


Then I make a normal ASP page that doesn't require a special service running

Using the GET method I will send the SQl statement

The content of the ASP page will include the serelized version of the this object

On the client side I deserialize the content of the asp page


It would be unusual for a .NET WinForms application to call ASP, rather than ASP.NET. ASP would probably have to use ADO, rather than ADO.NET to access any database - probably not what your existing data layer uses.

It is also more difficult to create bug free code in ASP compared with ASP.NET, as there's no intellisense.

A Web Service written using ASP.NET technology that passes datasets as (serialised) XML is the simplest method. Although, it sound like you wish to retrieve DTOs.

You have not explained what your existing data layer does - how do you perform CRUD operations? Do you use datasets, data readers,...?

Is your code object-oriented, or data(set) oriented? Etcetera, etcetera.
.

Quantcast