Re: .NET/ODBC queries Via the Internet by Jason
Jason
Thu Jul 17 05:42:01 CDT 2008
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.