I am creating a web application in vb.net. I want to send more than 200 records from server to client, so I have stored all the records in the dataset object and sending that object through socket. Now I know that I should serialize the object & send it through socket, but I am facing problem.
Here is my code:
sql = "Select Transaction_ID,Log_Date,Log_Time,Client_Action,Remarks from ClientLogs where Account_No=" & ClientAccountNumber & ""
dataadapter = New OleDbDataAdapter(sql, connection)
Dim send_to_client As Byte()
send_to_client = Encoding.ASCII.GetBytes(dataset & Chr(13))
networkStream.Write(send_to_client, 0, send_to_client.Length)
I have very little idea about binary serialization(I don't want xml serialization).
I tried to collect some info about <serializable()> but I didn't get much.Is there any way to send the data set object through socket using serializable class and deserialize the dataset object oat the server side.
In my project, database is at server side .
Any constructive suggestions are welcome.
Thanking you in advance