C#

Member 3137078 wrote:

Use stringbuilder to combine more string values together

for each row in a table
  instantiate a StringBuilder (with the default length of 16 no less!)
  for each column
    Append a comma (possibly with a test first)
    Append the value
  write it somewhere with ToString()

instantiate a StringBuilder (ideally with some estimate of how much space is required by the longest record)
for each row in a table
  set the StringBuilder's Length to 0
  for each column
    AppendFormat the value and a comma
  write it somewhere with ToString ( 0 , Length-1 ) to eliminate the extraneous comma

Thread thr;

Socket Soc = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
        IPEndPoint ipend = new IPEndPoint(IPAddress.Any, 8000);

private void buttonX1_Click(object sender, EventArgs e)
        {
            thr = new Thread(Listen);
            thr.Start();   
        }

 void Listen()
        {
            Soc.Bind(ipend);
            Soc.Listen(10);
            
            byte[] data = new byte[500];
            while (true)
            {
                // Accept the connection
                Socket client = Soc.Accept();
                client.Receive(data);
                sth = Encoding.ASCII.GetString(data);

                //send data
                //string send = textBox2.Text;
                //byte[] sending;
                //sending = Encoding.ASCII.GetBytes(send);
                //textBox2.Text = "";
                //
                //client.Send(sending);
                //
                client.Shutdown(SocketShutdown.Both);
                client.Close();
                
            }
            
        }

Socket soc = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
           IPEndPoint ipend = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 8000);
           //soc.Bind(ipend);
           soc.Connect(ipend);
           string input = textBoxX1.Text;
           byte[] data = new byte[500];
           data = Encoding.ASCII.GetBytes(input);
           soc.Send(data);
           string sth = "";
           sth = Encoding.ASCII.GetString(data1);
           textBoxX2.Text = sth;

Thread thr;
 
Socket Soc = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
        IPEndPoint ipend = new IPEndPoint(IPAddress.Any, 8000);
 
private void buttonX1_Click(object sender, EventArgs e)
        {
            thr = new Thread(Listen);
            thr.Start();   
        }
 
 void Listen()
        {
            Soc.Bind(ipend);
            Soc.Listen(10);
            
            byte[] data = new byte[500];
            while (true)
            {
                // Accept the connection
                Socket client = Soc.Accept();
                client.Receive(data);
                sth = Encoding.ASCII.GetString(data);
 
                //send data
                //string send = textBox2.Text;
                //byte[] sending;
                //sending = Encoding.ASCII.GetBytes(send);
                //textBox2.Text = "";
                //
                //client.Send(sending);
                //
                client.Shutdown(SocketShutdown.Both);
                client.Close();
                
            }
            
        }

Socket soc = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
           IPEndPoint ipend = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 8000);
           //soc.Bind(ipend);
           soc.Connect(ipend);
           string input = textBoxX1.Text;
           byte[] data = new byte[500];
           data = Encoding.ASCII.GetBytes(input);
           soc.Send(data);
           string sth = "";
           sth = Encoding.ASCII.GetString(data1);
           textBoxX2.Text = sth;

const string pattern = @"_(?<FileCode>([^_][a-zA-Z0-9])+)\.txt$";
const string text = @"Directory\Subdirectory\Subdir\Subsubdir\sub_sub_subv009\filename_with_lots_of_ABC123.txt";

var groupFileCode = Regex.Match(text, pattern);

Console.WriteLine(groupFileCode.Groups["FileCode"].Value);

// alternatively without regullar expressions
int lastUnderscoreIndex = text.LastIndexOf('_');
int lastPointIndex = text.LastIndexOf('.');

Console.WriteLine(text.Substring(lastUnderscoreIndex + 1, lastPointIndex - lastUnderscoreIndex - 1));

CREATE PROCEDURE dbo.Foo
  @StateCode AS CHAR(2),
  @OutVariable1 AS INT OUTPUT,
  @OutVariable2 AS INT OUTPUT
AS
BEGIN
  SET @OutVariable1 = 100
  SET @OutVariable2 = 150

  SELECT * FROM dbo.Persons WHERE State = @StateCode
END

string stateCode = "AL";
int outValue1 = 0;
int outValue2 = 0;

using (SqlConnection = new SqlConnection(connectionString)) {
    using (SqlCommand cmd = new SqlCommand("dbo.Foo") ) {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Paramaters.Add("@StateCode", SqlDbType.Char, 2) = stateCode;
        SqlParameter outValue1Param = cmd.Parameters.Add("@OutVariable1", SqlDbType.Int);
        SqlParameter outValue2Param = cmd.Parameters.Add("@OutVariable2", SqlDbType.Int);

        // Get Result Set
        using (DataReader dr = cmd.ExecuteReader()) {
            while ( dr.Read() ) {
                // Read datareader value
            }
        }

        // Get output values
        outValue1 = (int) outValue1Param.Value;
        outValue2 = (int) outValue2Param.Value;
    }
}