Well, i forgot to mention, but i also need to fire events from the server
application to the user control.
The goal of the server application isn't only to be a 'forwarder' of sql
query commands from clients to db, but also should fire events to client
when something happens (like packets received from the rs232 located on the
server).
I planned to use an exchange of UDP message between the 'server application'
and the user control to exchange events (from srvr -> client) and sql
queryes (from client->srvr). But i couldn't realize how to exchange sql
resulting recordsets.
Can i do this with web services too? or should i split the two tasks in
a) a server application that send udp messages to 'clients'
b) a web service that the 'clients' use to query the database
sorry for my bad english :)
Marco
"David Lloyd" <in**@LemingtonConsulting.com> ha scritto nel messaggio
news:ZN*****************@bignews3.bellsouth.net...
Marco:
The scenario you describe sounds very much like a case where you would use
a
web service. Since web services already use XML and SOAP, you will have
the
serialization in the format you require.
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or
warranties.
"M. Simioni" <m.*****************@TOCONTACTMEwooow.it> wrote in message
news:1R*****************@news.edisontel.com... Hi, the scenario should be like this:
I have a "Server" application, and a UserControl running on an asp.net
page. The UserControl sends a SQL Query string via UDP to the Server (after
some
sort of authentication, etc etc)
The Server Application executes the query on his local SQL2k server
The Server Application gets the recordset returned by query execution
Then the server application sends to the UserControl the recordset
returned by the query execution
Could this be done? Like using a sort of Serialization of the
SQLDataReader? Or should i use another tecnique?
My target is to avoid opening the SQLServer directly to the public
internet, but to redirect all the queryes to my application, using some sort of
authentication and encryption.
I'm nearly new to .net framework so i'm discovering new things every day.
Thanx a lot for the help, and for any link that will be useful
Marco