C#

ALTER proc sp_VeriEkle
(
	@cek_no nvarchar(10),
	@cek_tarih nvarchar(20),	
	@num1 nvarchar(10),	
	@num2 nvarchar(10),
	@num3 nvarchar(10),
	@num4 nvarchar(10),	
	@num5 nvarchar(10),
	@num6 nvarchar(10)
)
  as 
    Begin
         Insert into NumaraBilgileri(cekilis_no,cekilis_tarihi,num1,num2,num3,num4,num5,num6) values (@cek_no,@cek_tarih,@num1,@num2,@num3,@num4,@num5,@num6)
    End

for (int i = 0; i < table.Rows.Count; i++)
{
    cmd.Parameters.AddWithValue("@cek_no", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][0].ToString();
    cmd.Parameters.AddWithValue("@cek_tarih", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][1].ToString();
    cmd.Parameters.AddWithValue("@num1", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][4].ToString();
    cmd.Parameters.AddWithValue("@num2", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][5].ToString();
    cmd.Parameters.AddWithValue("@num3", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][6].ToString();
    cmd.Parameters.AddWithValue("@num4", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][7].ToString();
    cmd.Parameters.AddWithValue("@num5", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][8].ToString();
    cmd.Parameters.AddWithValue("@num6", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][9].ToString();

    cmd.ExecuteNonQuery();

  String Pname = LblName.Text;
 String Pdob = LblDOB.Text;
 String PnhsNo = LblNHSno.Text;
 String Paddress = RtxtBxAddre.Text;
 String PmedicalCon = RtxtBxMedCon.Text;
 String pcallOutDetails = RTxtBxCallOut.Text;

 byte[] forwardMessage = Encoding.ASCII.GetBytes(Pname + Pdob + PnhsNo + Paddress + PmedicalCon + pcallOutDetails);
sock.Send(forwardMessage);

 sock.Shutdown(SocketShutdown.Both);
 sock.Close();

Socket listener = new Socket(AddressFamily.InterNetwork,SocketType.Stream,ProtocolType.Tcp);
          listener.Bind(new IPEndPoint(IPAddress.Any, 2112));
          listener.Listen(10);

                  
           Socket socket = listener.Accept();
           string receivedValue = string.Empty;

           
                     byte[] receivedBytes = new byte[1024];
                      int numBytes = socket.Receive(receivedBytes);
                          
                              receivedValue = Encoding.ASCII.GetString(receivedBytes,0, numBytes);
                             
                                    MessageBox.Show(receivedValue);
                                                                    
                                    listener.Close();