@shandye2
Maganda yang idea mo brod, i TRIED doing that din long time ago.
Question lang, and ideas, i hope you wont mind
How do you plan to send hundreds of records over the winsock connection?
for example gusto ng client na mag display sa grid ng recordset containing 1000 records,
nakooo katakot takot na parsing yan
--- iconvert mo ba sa delimited string record by record then parse sa kabila?
--- have you considered the speed issue when sending lots of string data?
--- have you experienced na ba na nabubulunan yung recieving end kasi mas mabilis mag send kesa mag recieve at mag parse?
----have you experienced na na dikit dikit ang mga records? or improperly delimited?
----ano gagawin mo kung yung isang record e corrupted?
my suggestion is to convert it to XML, since string na yun mas madali i send at basahin sa kabilang dulo.
since recordset na sya pagdating sa kabila, yung code mo halos walang change when using ADO
Code:
Dim xmlRS As New MSXML2.DOMDocument50
Dim db as New ADODB.Connection
Dim rsTemp As New ADODB.Recordset
dim strConnect as String
strConnect = "Some valid connection string"
db.CursorLocation = adUseClient
db.open strConnect
rsTemp.Open "Select * From tblClients",DB,adStatic,adReadOnly,adCmdText
set rsTemp.ActiveConnection = Nothing
rsTemp.Save xmlRS, adPersistXML
Winsock1.SendData xmlRS.xml 'Sends the recordset as an XML
recordset
Code:
Eto naman sa kabilang dulo para mabuksan yung recordset na ipinadala
WinSock1.DataArrival:
dim strData as String
Dim xmlRS As New MSXML2.DOMDocument50
Dim rsTemp As New ADODB.Recordset
WinSock1.GetData strData
xmlRS.LoadXML strData
rsTemp.Open xmlRS
'ADO recordset ka na dito, so same coding nalang pag gusto mo i display sa ano mang control(grid, listview, etc)
i have made applications using winsock and SAXCOMM over the years, meron pa yung dumadaan sa GPRS modem and i have experience lots of limitations
best solution dyan is to use WebService or Remoting or WCF sa .NET
dun pde ka mag send ng buong dataset without worrying
kung papano dadating sa kabila, all are taken cared of.
maski over the internet gagana yan.