C#

Mc_Topaz wrote:

Your replay is just meaningless.

Mc_Topaz wrote:

I tried to be polite

tcp.Client.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.ReuseAddress, true);
tcp.Client.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.DontLinger, true);

static void Test(IPEndPoint local, IPEndPoint remote, byte[] request)
{
    byte[] response = new byte[0];

    using (TcpClient tcp = new TcpClient())
    {
        try
        {
            tcp.Client.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.ReuseAddress, true);
            tcp.Client.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.Linger, 0);
            tcp.LingerState = new LingerOption(false, 0);

            tcp.Client.Bind(local);
            tcp.Connect(remote);

            using (NetworkStream stream = tcp.GetStream())
            {
                try
                {
                    stream.Write(request, 0, request.Length);

                    Thread.Sleep(500);

                    response = new byte[tcp.Available];
                    stream.Read(response, 0, response.Length);
                }
                catch (SocketException soe)
                {
                    Console.WriteLine(soe.ErrorCode);
                    Console.WriteLine(soe.SocketErrorCode);
                    Console.WriteLine(soe.Message);
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
        }
        catch (SocketException soe)
        {
            Console.WriteLine(soe.ErrorCode);
            Console.WriteLine(soe.SocketErrorCode);
            Console.WriteLine(soe.Message);
        }
        catch (Exception e)
        {
            Console.WriteLine(e.Message);
        }
        finally
        {
            if (tcp.Connected)
            {
                tcp.Client.Shutdown(SocketShutdown.Both);
            }
        }
    }

    Console.WriteLine("Received: {0} byte(s)", response.Length);
}

await tcp.ConnectAsync("host", 12345);
if (tcp.Connected)
{
    using (var stream = tcp.GetStream())
    {
        await stream.ReadAsync(buffer, 0, buffer.Length);
    }
}

public void Data(string colName)
{
    OpenDB();
    string strCmd = "Data";
    SqlCommand cmd = new SqlCommand(strCmd, conn);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add(new SqlParameter("@col", SqlDbType.VarChar, 50));
    cmd.Parameters[0].Value = colName;
    cmd.ExecuteNonQuery();
    conn.Close();
}

string x = this.textbox1.text;
x=x.Replace("+", "{+}");
//Repeat this step for all the special characters. They are listed here if you want: https://msdn.microsoft.com/it-it/library/system.windows.forms.sendkeys.send(v=vs.110).aspx