I have the task to create a tier 2 application as follows:
MSSQL Database <-> Server <-> n-Client (n for many)
The client sends data to the server. The server selects stuff from the database and then sends it back to the client. Currently I am doing that with Records and SendDataToSocket(url is below).
I want to use TDBGrid on the client using data received via sockets from the server. At the moment it goes like this:
Server: DB -> ADOQuery -> DataSetProvider -> ClientDataSet -> SaveToStream(MemoryStream)
Client: ClientDataSet -> LoadFromStream(MemoryStream) -> DataSource -> DBGrid
So what I want to do is send the stream the clientdataset on the server side creates to the client who uses loadfromstream to read the stream. Is the SendDataToSocket viable here?
I hope you get what I mean.