如何通过socket发送和接受dataset数据集(C#)

原文网址：http://bjutales.blogbus.com/logs/60616582.html

如何通过socket发送和接受dataset数据集(C#) - [computer]

版权声明：转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://bjutales.blogbus.com/logs/60616582.html

//以下是属于客户端的代码

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;
using System.Net.Sockets;
using System.Data.SqlClient;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.Net;

namespace ConsoleApplication1
{
     class Program
     {  
         public static byte[] GetBinaryFormatDataSet(DataSet ds)
         {
             //创建内存流
             MemoryStream memStream = new MemoryStream();
             //产生二进制序列化格式
             IFormatter formatter = new BinaryFormatter();
             //指定DataSet串行化格式是二进制
             ds.RemotingFormat = SerializationFormat.Binary;
             //串行化到内存中
             formatter.Serialize(memStream, ds);
             //将DataSet转化成byte[]
             byte[] binaryResult = memStream.ToArray();
             //清空和释放内存流
             memStream.Close();
             memStream.Dispose();
             return binaryResult;
         }

         static void Main(string[] args)
         {
             //
             // TODO: 在此处添加代码以启动应用程序
             //
             SqlConnection conn = new SqlConnection("server=.;database=news;uid=sa;pwd=sa;");
            
             conn.Open();
             String selstr = "select * from newsType";
             SqlDataAdapter adapter = new SqlDataAdapter(selstr, conn);
             DataSet ds = new DataSet();
             adapter.Fill(ds, "phonetab");
             conn.Close();
             byte[] input = GetBinaryFormatDataSet(ds);

             try
             {
                 //远程的ip地址和端口号
                 IPAddress ip = System.Net.IPAddress.Parse("127.0.0.1");
                 IPEndPoint ipep = new IPEndPoint(ip, 3434);
                 Socket server = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);

                 try
                 {
                     server.Connect(ipep);
                 }
                 catch (Exception e)
                 {
                     Console.WriteLine(e.ToString());
                 }
                 server.Send(input);
                 byte[] response = new byte[1024];
                 int bytesRead = server.Receive(response);
                 Console.WriteLine(Encoding.ASCII.GetString(response, 0, bytesRead));
                 server.Shutdown(SocketShutdown.Both);
                 server.Close();
             }
             catch (Exception e)
             {
                 Console.WriteLine(e.ToString());
             }
             Console.ReadLine();         
         }  
     }
}

 

//一下是属于服务器端的代码

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;
using System.Net.Sockets;
using System.Data.SqlClient;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
using System.Net;
namespace ConsoleApplication2
{
     class Program
     {
         public static DataSet ds;
         public static DataSet RetrieveDataSet(byte[] binaryData)
         {
             //创建内存流
             MemoryStream memStream = new MemoryStream(binaryData);
             memStream.Seek(0, SeekOrigin.Begin);
             //产生二进制序列化格式
             IFormatter formatter = new BinaryFormatter();
             //反串行化到内存中
             object obj = formatter.Deserialize(memStream);
             //类型检验
             if (obj is DataSet)
             {
                 DataSet dataSetResult = (DataSet)obj;
                 return dataSetResult;
             }
             else
             {
                 return null;
             }
         }
         static void Main(string[] args)
         {

             IPAddress ip = System.Net.IPAddress.Parse("127.0.0.1");
             IPEndPoint ipep = new IPEndPoint(ip, 3434);
             Socket lst = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
             lst.Bind(ipep);
             lst.Listen(20);

             while (true)
             {
                 Console.Write("等待连接.......");
                 Socket client = lst.Accept();
                 Console.WriteLine("客户已连接");

                 byte[] request = new byte[512];
                 int bytesRead = client.Receive(request);
                 //ds = RetrieveDataSet(request);
                 string input = Encoding.ASCII.GetString(request, 0, bytesRead);

                 Console.WriteLine("客户请求：{0}", input);

                 string output = "hello, " + input + "!";
                 byte[] hello = Encoding.ASCII.GetBytes(output);

                 try
                 {
                     client.Send(hello);
                     client.Shutdown(SocketShutdown.Both);
                     client.Close();
                 }
                 catch (Exception e)
                 {
                     Console.WriteLine(e.ToString());
                 }
             }

         }

     }
}