If you don't need the n-tier model, then you can simply connect to
database on server directly from the client and when you have direct
access to database you can create datatable or do whatever you want
with the database. However if you want some kind of separate data
layer, then you should use a webservice on the server which will
serialise the dataset as XML and you need to deserialise it again on
client. .net remoting can also be a choice for you. I am not an expert
in any of these areas however.
You may like to check following article:
http://msdn2.microsoft.com/en-us/library/ms978496.aspx
Regards,
Sachin Palewar
(Certified Scrum Master)
Palewar Techno Solutions
(Mobile Solutions for Your Business)
www.palewar.com
On Mar 30, 10:22 pm, "tclancey" <t...@idcodeware.co.ukwrote:
Hi All.
I've been trying to think of a way to pass datasets, or tables from one PC
to another.
This would be the scenario.
Client PC sends an SQL query to a 'server'.
The 'server' would make a connection to a back end database.
The 'server' would retrieve data and send it back to the client.
It would basically be a way to avoid many PC's connecting to a back end
database.
I'm sure the way to handle the data transfer would be through sockets, but
how would I send a data table?
Any ideas?
Cheers,
Tull.